Get All SESSIONPROPERTY Values for Your Session
As a follow-up to my SERVERPROPERTY() post, this is a quick script to grab all the SESSIONPROPERTY() values from your current session in a table. Useful when you forget...
2011-08-23
2 reads
As a follow-up to my SERVERPROPERTY() post, this is a quick script to grab all the SESSIONPROPERTY() values from your current session in a table. Useful when you forget...
2011-08-23
2 reads
Demo files from my presentation at Dallas Tech Fest 2011.
SQL Server CLR – An Introduction – Dallas Tech Fest 2011
2011-08-12
708 reads
In a continuation of my previous LOGON TRIGGER post.
A downside to SQL logins is that anyone with the username / password...
2011-06-18
2,115 reads
Yesterday I was trying to drop some hypothetical indexes in production against a fairly active table. I started causing blocking...
2011-05-12
6,395 reads
I had a need today to disable all of our admin jobs while I moved our admin database to another...
2011-04-25
2,191 reads
A quick script to grab all the SERVERPROPERTY() values from a SQL instance in a table. Useful when you forget...
2011-04-14
6,745 reads
Yesterday, I was tasked with helping a team move their BizTalk databases to another server. These are my notes for...
2011-04-08
1,419 reads
Thomas LaRock (Blog | Twitter) has started a community blog series call Meme Monday.
Here’s my entry:
Community is nice, but displaces work if...
2011-04-04
728 reads
SQL Saturday #63 – Dallas was a great event. The venue was great, although parking was a little unclear (I had...
2011-04-04
780 reads
I had the opportunity to present my “What Can You Do With PowerShell?” session in Dallas at SQL Saturday #63....
2011-04-02
635 reads
By Ed Elliott
When I first started working with Apache Spark, one of the things I struggled...
By Andy Warren
I think our profession was the better for having a professional association, even if...
By Andy Warren
in my last post I wrote about thinking of the tools as being a...
1. What is the difference among nested loop?hash join and merge join? 2. what...
Dear Group: I am not sure if this is a T-SQL / SSMS issue,...
Hello i have linked server one server in cloud one is local from local...