PASS Business Analytics Conference
The PASS Business Analytics Conference is almost here! Check out the sessions to be presented at the conference and you will see...
2013-04-08
929 reads
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
721 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
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
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...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers