Event Notifications 101 – Intro to Event Notifications
Once upon a time, in a blog post far, far away, I started talking about auditing in SQL Server. And...
2013-04-15
652 reads
Finding SQL Server Installs with Powershell, Again
But the SQL Listener isn’t started!
Yep, I heard you loud and clear. There is more than one way to find...
2013-04-15
934 reads
SQL Server – Import Data from Excel using T-SQL
To import data from an Excel file to SQL Server you can use SQL Server Import and Export Wizard. You...
2013-04-15
29,006 reads
DMV-7 : Find Queries waiting for memory ?……..sys.dm_exec_query_memory_grants
sys.dm_exec_query_memory_grants DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-IN/library/ms365393.aspx
Returns information about the queries that have acquired a memory...
2013-04-15
1,061 reads
Determining when statistics were last updated in SQL Server?
I received an email from friend today asking how he can see when statistics were last updated in SQL Server....
2013-04-15
3,485 reads
PASS SQL Saturday in Chicago Presentation Slides
Thanks to everyone who attended my sessions “What exactly is Business Intelligence?” and “Building an Effective Data Warehouse Architecture” at the PASS SQL...
2013-04-15
759 reads
PASS Business Analytics Conference Presentation Slides
Thanks to everyone who attended my sessions “Overview of Microsoft Appliances” and “Building an Effective Data Warehouse Architecture” at the PASS Business Analytics...
2013-04-15
706 reads
Calculating the length of a string (Len vs DataLength)
This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers...
2013-04-15
1,431 reads
On the move
Its been a fair few years since I started blogging on SQLBlogCasts and the time has now come to find...
2013-04-14
623 reads
Consolidating Error Logs from multiple SQL Servers using SSIS
SQL Server stores all informational messages, warning messages, and errors in operating system and application log files. As a database...
2013-04-14
929 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers