SQL Saturday in Rochester Exceeds Expectations
After being forced to deliver sour grapes in my last few columns – thanks to some unexpectedly negative experiences with Oracle...
2012-05-29
1,758 reads
Blog Posts
SSRS Performance in SharePoint Integrated Mode
I’m working with a client to help them move all reports in their company from native mode (Reporting Services not...
2012-05-29 (first published: 2012-05-24)
4,905 reads
The Rules of Gibbs
It’s been interesting to watch the characters evolve on NCIS over the years, something that can only happen with time...
2012-05-29
843 reads
The Standing Desk Experiment
I’ve had a few friends using standing desks for sometime. I first heard about Greg Gonzalez (sqlSentry | Blog | @SQLSensei), fellow...
2012-05-29
1,958 reads
Always restore with NORECOVERY
Always, always, ALWAYS restore a SQL Server database with the NORECOVERY option.
It’s trivial to switch the database online.
Not...
2012-05-28 (first published: 2012-05-24)
7,060 reads
Denali – Day 28: CDC for ORACLE
Denali – Day 28: CDC for ORACLE Sql server has provided a great features for changes monitoring as Change data Capture...
2012-05-28
1,351 reads
NVARCHAR(n) Vrs NVARCHAR(max)
These datatypes particularly NVARCHAR(n), have been with us for some time now but having seen some of the confusion around...
2012-05-28
7,934 reads
On my way to DevTeach in Vancouver
Just stepping out the door on on my way to the DevTeach / SQL Teach conference in Vancouver, BC, Canada. The...
2012-05-28
969 reads
Rolling out Windows 8 Client: First Impressions
A virus found it’s way on to my system through a trojan horse, past all the security & anti-virus software. I...
2012-05-28
1,028 reads
SQL Server – DDL vs. DML Triggers
Although, DML and DDL triggers are used for different purposes, there are some similarities and differences between these.
Similarities between DDL...
2012-05-28
1,627 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
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
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...
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