2014 Event Kickoff
I know that this coming year, 2014, is going to be my best year yet! I’m starting 2014 off with...
2013-12-17
715 reads
Transactions: Rolling back a nested transaction
Transactions are great and wonderful things. They make sure that our work stays atomic, consistent, isolated and durable (yes ACID)....
2013-12-17
1,532 reads
I’m Board
No, really, I’m board. It will be officially announced today, but as of December 11th, I’m the new Director of...
2013-12-17
567 reads
Collecting Historical IO File Statistics
In a previous post, Collecting Historical Wait Statistics, I discussed how you can easily collect historical wait stats by using...
2013-12-17
1,476 reads
Database Recovery: Day 7
Recently we were talking about Backups and how you need to test them often. The most complete way to test...
2013-12-17
642 reads
Changed SoundEx Disables Index While Upgrading to SQL 2012
Implementation of SoundEx function is changed in SQL Server 2012, described here. For an example, the result of SOUNDEX(‘Csomorova’) in SQL Server 2012 is C561 whereas the result of...
2013-12-17
15 reads
Changed SoundEx Disables Index While Upgrading to SQL 2012
Implementation of SoundEx function is changed in SQL Server 2012, described here. For an example, the result of SOUNDEX(‘Csomorova’) in...
2013-12-17
990 reads
SQL Saturday in Ancona and Verona – English slide decks available for download
You can download the english version of my sessions at SQL Saturdays (on SlideShare):
SQL Saturday 257 in Verona: “Put databases...
2013-12-16
306 reads
Symmetric Keys
One of the encryption options in SQL Server is symmetric key encryption. This is the type of encryption most people...
2013-12-23 (first published: 2013-12-16)
2,943 reads
Last Weeks Top “Reading” Links #62
Monday afternoon and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout most days I tweet...
2013-12-16
1,386 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Alamat BCA KCP Kemang Telp/Wa:0821-8200-174
Telp/Wa:62 8218200174 Jl. Kemang Sel. No.60, RT.4/RW.2, Bangka, Kec. Mampang Prpt., Kota Jakarta Selatan,...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers