Copy / Paste Code
Copy / Paste formatted text is a nightmare in WordPress. I’m singling out WordPress because I use it, and, from what...
2013-05-13
609 reads
Blog Posts
DMV-10 : Does my database contain edition specific features?……..sys.dm_db_persisted_sku_features
sys.dm_db_persisted_sku_features (Introduced in SQL Server 2008) DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-in/library/cc280724.aspx
Some features of the SQL...
2013-05-13
2,095 reads
How to Tell Your Windows Azure SQL Database Moved
The very concept of the Windows Azure SQL Database (WASD) is predicated on the up-time created by having three active copies...
2013-05-13 (first published: 2013-05-07)
1,587 reads
Last Weeks Top “Reading” Links #32
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-05-13
668 reads
SQL Server – How to Move Table to Another Schema
Starting with SQL Server 2005 all tables are grouped into schemas. While creating a table if the schema name is...
2013-05-13
1,828 reads
Use Powershell to find and punish – er, delete – rogue files
I like to know what’s on the drives that are supposed to be dedicated to data and log files. So I...
2013-05-13
1,089 reads
Security Questions: What permissions are required to create temporary tables?
As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-12
763 reads
Database Assessment
This script looks much more intimidating than the results it produces, so I recommend running it before reading through it. ...
2013-05-11
479 reads
Database Administration KPIs – 2/2
In my last post, I discussed about the quantitative KPIs which, to me, are useful for “outsiders”, i.e. non-DBAs, to...
2013-05-10 (first published: 2013-05-04)
5,208 reads
Drafting Email You’ll Never Send-Probably
It’s not uncommon to get frustrated about something at work and send out an email blasting whatever person or group...
2013-05-10
707 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers