More in Development

  • SQL Server data storage rack
    Jun 26, 2012
    blog

    Disk Space Monitoring: How To 1

    Keeping tabs on available disk space on your SQL Servers is something that every DBA should do—because once SQL Server runs out of disk on the underlying host, then everything obviously comes to a crashing halt....More
  • Jun 14, 2012
    blog

    SQL Server Database Corruption, Part XIII: RECAP

    One of the things I wish I had done a bit better in my previous ‘series’ of posts on SQL Server database corruption was provide better links and cohesion between posts—or a ‘table of contents’ at the top or bottom of each post—just because I always appreciate similar efforts when I stumble upon a series of posts via a set of keywords I’m searching for and so on....More
  • May 31, 2012
    blog

    SQL Server Database Corruption, Part XII: Recovery Sample 2

    In my last post in this ongoing series on SQL Server database corruption I mentioned that my next post would be to provide a ‘soup to nuts’ sample or example of how you can test corruption and recovery in your own environment – as a means of better getting familiar with exactly what corruption is, what it looks like, and how to address it....More
  • green corrupt data illustration
    May 25, 2012
    blog

    SQL Server Database Corruption, Part XI: Full Recovery Operations 1

    In part 9 of this series on SQL Server database corruption I defined a list of key things to do when responding to database corruption. And in that list of options and operations was the mention that in some cases you may have to revert back to using a full-blown recovery operation – meaning that you’ll need to completely restore your database from scratch....More
  • table data on white piece of paper
    Feb 27, 2012
    blog

    How about Filtered Indexes instead of Partitioning?

    Filtered indexes are an incredibly powerful feature (one of my favorites) so I don't want to dissuade you from using them. A table can be partitioned using the partitioned tables feature. A table can be broken into multiple tables and then unioned (UNION ALL) in a view using the "partitioned views" feature....More
  • Feb 9, 2012
    blog

    Solutions to VLT concerns around statistics and maintenance! 2

    Let's tackle why partitioned views can be a fantastic choice for partitioning large sets—even for new design....More
  • illustration of data with colorful numbers in background
    Feb 2, 2012
    blog

    Partitioned Tables v. Partitioned Views–Why are they even still around? 1

    Partitioning is CRITICAL for VLT. What is VLT? It’s about as descriptive as VLDB and it means very large table. Most people speak of VLDBs (very large databases) and they define that as databases that are 100s of gigabytes (many would say that a database that’s 1TB or larger is a VLDB)....More
IT/Dev Connections

Register now to get the best rate available!

From the Blogs
computer keyboard with blue save money key
Apr 15, 2014
blog

Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups 1

Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
Apr 8, 2014
blog

NoSQL: Eventual Consistency Yields Major Flaws 1

While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Apr 1, 2014
News

SQL Server 2014 Now Available—No Joke

Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×