Cluster Info
This script is so simple you’ll start off by asking why you’d ever use it. Then you’ll use it and...
2013-05-14
617 reads
File Sizes
There are two scripts I like to use to look at the file sizes on servers. The first one is...
2013-05-14
454 reads
PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers
We came across a scenario where database bak files being created from long time which are no more in use...
2013-05-17 (first published: 2013-05-13)
2,447 reads
The Tale of One Tabular Model and Excel 2013 with Multiple Power View Reports
SQL Server 2012 Reporting Services introduced Power View, which was initially available only in SharePoint. This limited the use of...
2013-05-16 (first published: 2013-05-13)
3,449 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
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,088 reads
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
608 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
Dragging a name from the object explorer to a query window
In the same vein as Steve Jones’ series on Customizing SSMS this is a fairly basic trick, but one that...
2013-05-16 (first published: 2013-05-13)
3,855 reads
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
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
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...
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