Counting code lines in SPs with Powershell
One of interesting tasks I once had is to check the # of code lines for all user stored procedures (SPs)...
2011-08-14
1,412 reads
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,180 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,261 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
657 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,293 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,633 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,355 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,387 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
651 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,314 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCU HARAPAN INDAH Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Sentra Niaga Jl. Harapan Indah Boulevard Kav. CP2 No. 1, RT.10/RW.8,...
Layanan BCA KCU SOEKARNO HATTA Telp:0817°82°5533
Telp/Wa 62817825533 Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung, Jawa Barat...
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers