A DMV a Day – Day 12
The DMV for Day 12 is sys.dm_db_partition_stats, which is described by BOL as:
Returns page and row-count information for every partition...
2010-04-12
843 reads
Blog Posts
April OPASS Meeting Featuring Joe Webb
Tomorrow night, April 13th, at 6pm we will be having our April OPASS meeting, sponsored by Veredus Orlando with Joe...
2010-04-12
436 reads
Book Review: Crush It!
Not long ago, I read a review of Gary Vaynerchuk’s book, Crush It! The reviewer, Michael Hyatt (Twitter | Blog), liked...
2010-04-12
470 reads
Bug: Reporting Services 2K8, SSMS and Windows 7
[Edit] Since writing this, I've realized that the true reason behind this was that my account was not a member...
2010-04-12
1,124 reads
db_executor role
This process might not be granular enough for some but there is a nice simple way of creating a role...
2010-04-12
34,748 reads
How Can I Tell if a Windows Login has Rights to My Server?
Introduction
Here is another utility stored procedure that I use. This stored procedure will tell you how a user has access...
2010-04-12
316 reads
New SSDs
I ordered a few recently from NewEgg. One for a desktop, one for a laptop. We’ll see how they do,...
2010-04-12
408 reads
Notes from the R2 Tweetup
Several weeks ago I was invited to attend a ‘tweetup’ by Microsoft on April 8th, an almost all expenses paid...
2010-04-12
435 reads
PASS BI Virtual Chapter – Thursday’s Session Postponed
The PASS BI Virtual Chapter’s scheduled session for this Thursday, April 15th, will have to be postponed until a later...
2010-04-12
660 reads
Reporting Services 2008 R2 Data Bars
Last week I wrote a blog explaining how the new tool inside Reporting Services 2008 R2 called Indicator will be...
2010-04-12
2,085 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers