More in T-SQL

  • 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
  • Nov 17, 2011
    blog

    What's a good use for a UNIQUE filtered index? 3

    Learn more about SQL Server UNIQUE filtered indexes and a minor limitation you'll need to know about....More
  • Oct 2, 2011
    blog

    SQL Server 2012 T-SQL at a Glance: New and Enhanced Functions

    Itzik describes new T-SQL scalar functions in SQL Server 2012 CTP 3....More
  • Sep 25, 2011
    blog

    Semicolon 3

    Not terminating T-SQL statements with a semicolon is on a deprecation path....More
  • Microsoft SQL Server Database Properties Auto Close screenshot
    Sep 8, 2011
    blog

    Worst Practice: Allowing AutoClose on SQL Server Databases

    Simply stated, allowing or enabling AutoClose on production SQL Server databases is a worst practice. What is AutoClose and why is it bad? AutoClose is a database option or setting—set on a database by database basis (meaning that it can’t be controlled at the server level)....More
  • Aug 31, 2011
    blog

    Improved Support for Window Functions in SQL Server 2012 CTP3

    Itzik describes the enhanced support for window functions introduced in Microsoft SQL Server Denali CTP3....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

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

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) ×