A second week at SQLskills – performance tuning
G’day,
Back in February, I was lucky enough to attend a week of training on SQL internals from the people at...
2011-08-14
1,175 reads
Recursively Enumerating Local and AD Groups
If you ever need to flatten out groups which may include nested local and AD groups there’s a really easy...
2011-08-14
4,254 reads
Great new analytical functions in SQL Server 2011 “Denali”
SQL Server 2011 “Denali” is quite rich for new functions which have really good practical use in T-SQL. I’ve read...
2011-08-14
656 reads
Change User Desktop Folder Path by Using PowerShell
We could change your desktop folder location by using the following powershell script. Actually we need to change values of...
2011-08-14
5,274 reads
Gradually Deleting Data in SQL Server
If you have a situation where you have a very large table in SQL Server, where you need to periodically...
2011-08-13
1,626 reads
Database Administration Operation Road Map
In my company, every two years, we have a tradition to collectively ponder at the technology road map for the...
2011-08-13
2,348 reads
SQL MCM Training – Day 5
Today I've not taken too much notes, because the whole afternoon was about the Management
Data Warehouse and Multi-Instance Management. But...
2011-08-13
1,380 reads
Can You Dig It? – Researching Index Scans
Follow the rest of this series at the Can You Dig It? – Plan Cache series introduction post.
"She can dig it!"...
2011-08-12
643 reads
Interview with SQLServerCentral.com Editor Steve Jones
Steve Jones will be speaking at the SQLServerCentral.com track at SQL Server Connections, October 31-November 3, 2011, in Las Vegas,...
2011-08-12
1,310 reads
Dallas Tech Fest – Demo Files for SQL Server CLR: An Introduction
Demo files from my presentation at Dallas Tech Fest 2011.
SQL Server CLR – An Introduction – Dallas Tech Fest 2011
2011-08-12
723 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Alamat BCA KCP Semanggi Telp/Wa:08218200203
Hub Cs 08218200203 Wisma GKBI, Jl. Jenderal Sudirman No.28 Suite G 01, RT.14/RW.1, Bend....
Alamat BCA KCP Kwitang Telp/Wa:08218200233
Hub Cs 08218200233 Jl. Kramat Kwitang No.29, RT.1/RW.4, Kwitang, Kec. Senen, Kota Jakarta Pusat,...
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers