culture independent format
network bind order
sql 2008 r2
SQL Server Configuration Manager
SQL Server SQLServer 2008R2
User-Defined Server Roles
Browse by Tags
Tagged Content List
Keep track of the DML changes:
Last week, one of my customers asked me how to track DML code. He had a scenario in which he needed to update a table and keep the old data. In the past, developers and DBAs have used custom code to track changes, stored procedures, triggers and CDC. Starting with version 2005, SQL Server supports...
7 Aug 2013
The scenario of a missing SA password:
You are the senior DBA of your organization, responsible for all the databases that hold the critical info. In order to secure the environment and the databases, you performed the next recommended steps: 1) Remove all built-in admin account from SQL Server logins. 2) Remove all users from SYSADMIN...
22 Jul 2013
SQL 2012 System health–fast analysis
Once we encounter a few problems with the SQL 2012 and we need to analyze it, what will be the first recommended step to start with? During my last post I have discussed the default trace in SQL and its benefits. SQL 2008 introduced a new option called extended events (which is also know as Xevents...
24 Mar 2013
How to avoid text-to-date conversion mismatches
In one of our previous posts we saw how different set options can affect execution plans and result sets. Now let's see how to write our code in order to avoid text-to-date conversion mismatches. In this example we can see one string being converted to two different dates: set language...
14 Jan 2013
Stop using TOP to page for data from now on use the OFFSET
With all the innovation that SQL 2012 bring to us in the T-SQL area we have the offset command. What is the offset command? I early version of SQL (before 2012) when we wanted to select out of a table a number of row we all have used the TOP command, the top command is selecting the number applied...
29 Oct 2012
Page 1 of 1 (5 items)
© 2013 Microsoft Corporation.
Privacy & Cookies