The Public Role – a potential high risk security concern for DBAs
The public role is a special fixed-database role, which exists in every SQL Server database. The public role is different from all other database-level...
2013-04-24
11,144 reads
SQL Server index related dynamic management views and functions (Part 2)
SQL Server uses indexes to sort and organize table data. It creates indexes based on ordering values from one or...
2013-04-24
783 reads
The 200 Billion Dollar Tweet
Hello Dear Reader! Ever try to convince someone that they should be paying attention to Twitter? A co-worker, Vice President...
2013-04-24
1,130 reads
Building My HDInsight Server Cluster
After all the hype about Big Data, Hadoop, and now HDInsight, I decided to build out my own big data...
2013-04-24
968 reads
SQL Power Doc Update - Version 1.0.1.0
A quick note to let you know that SQL Power Doc version 1.0.1.0 is now live. This release fixes issues...
2013-04-24
1,038 reads
How do I tell the stored procedure name from inside the stored procedure?
I’ve occasionally had the problem of trying to put “smart” logging messages into a process. You know the ones, you’re...
2013-04-24
805 reads
Estimate Table Size based on the Metadata from INFORMATION_SCHEMA.COLUMNS
A problem I face often is not knowing the size of a new table that I’m creating. I put some...
2013-04-24
717 reads
VMworld Presentation Voting – I Would Appreciate Your Votes
This year is the first year that I have submitted a session to VMware’sVMworld 2013, to be held in San...
2013-04-24
609 reads
Looking Back
In July 2011 I took what felt like a big chance and a detour to lead a large and complex...
2013-04-24
733 reads
DMV-8 : Check Space consumed by Database……..sys.dm_db_file_space_usage
sys.dm_db_file_space_usage DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms174412.aspx
Returns space usage information for each file in the database.
It’s...
2013-04-24
3,017 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