Scripting Linked Servers
A co-worked asked me to look at a T-SQL script I had written 8 years ago for scripting out linked...
2010-07-06
2,971 reads
A co-worked asked me to look at a T-SQL script I had written 8 years ago for scripting out linked...
2010-07-06
2,971 reads
The Microsoft Clustering and High Availablity bloggers have taken noticed of the Remote Desktop Connection Manager (RDCMan) utility from a...
2010-06-30
1,588 reads
My thanks to everyone in attendence and PASS AppDev VC for inviting me to speak. I’ll post a link to...
2010-06-23
975 reads
On Tuesday June 22nd 9 PM Eastern I”m presenting ETL with PowerShell for PASS AppDev VC—a virtual chapter of Professional...
2010-06-20
1,013 reads
Remote Desktop Connection Manager or RDCMan is a free download from Microsoft for managing multiple remote desktop connections. The functionality...
2010-06-15
2,031 reads
After the first release of SQLIse (“SQL Ice”)--a basic IDE for T-SQL that includes ability to edit, execute, parse, format...
2010-06-04
1,558 reads
With the release of SQL Server 2008 R2 there have been claims that sqlps is really PowerShell V1 under the...
2010-05-28
5,457 reads
If you have experience with the SQL Server Agent you quickly realize the difficulty in managing job schedules. On a...
2010-05-15
4,547 reads
In case you’re wondering about the title T-SQL Tuesday, it’s a monthly collection of SQL Server related content where a...
2010-05-11
3,617 reads
Automating SQL Server Integration Services (SSIS) administration through PowerShell is very different than writing scripts against the core database engine....
2010-04-13
1,183 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers