Chicago SQL Saturday (#SQLSat211) Is This Weekend
The Chicago SQL Saturday is coming up this weekend on Saturday, April 13th. If you are waiting until the last minute...
2013-04-08
521 reads
Last Weeks Top “Reading” Links #27
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-08
488 reads
How Much Power Does Your PC Use?
I can’t say I’ve ever worried too much about how much power my PC uses. I care about battery life...
2013-04-08
771 reads
Thirty Hours at Home
This is a busy travel week for me, and one of those times that stresses out everyone in the household....
2013-04-08
719 reads
SQL Server : Part 9 : Filtered Index : A new way for Performance Improvemnt
Filtered index is a new feature introduced in SQL Server 2008. All the indexes that we have discussed till now...
2013-04-08
6,182 reads
list of the service applications in SharePoint 2010
Hey Friends,
It’s been a long time , I was out of touch with my blogs. But thanks to all for checking...
2013-04-08
970 reads
Restoring databases to a set drive and directory
Restoring databases to a set drive and directory
Introduction
Often people say that necessity is the mother of invention. In this case...
2013-04-08
890 reads
DMV-5 : Queries runing are adhoc or proc , single or multi use ?……..sys.dm_exec_cached_plans
sys.dm_exec_cached_plans DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-us/library/ms187404.aspx
Returns a row for each query plan that is cached...
2013-04-08
832 reads
Procedural Justice In Database Administration
According to Wiki, Procedural Justice (PJ) means:
Procedural justice is the idea of fairness in the processes that resolves disputes and...
2013-04-07
335 reads
Procedural Justice In Database Administration
According to Wiki, Procedural Justice (PJ) means:
Procedural justice is the idea of fairness in the processes that resolves disputes and...
2013-04-07
761 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