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
784 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,135 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
970 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,039 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
816 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
718 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
737 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,024 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Designing for Teams
Comments posted to this topic are about the item Designing for Teams
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers