Cannot Connect to SQL Server
I recently installed a new SQL Server 2008 instance on a brand new Windows 2008 R2. When I tried to...
2010-06-07
643 reads
Blog Posts
Daily SQL Server 2008 New Feature – Day 17
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-07
481 reads
Defensive Database Programming Chapter 01
Today I am finally getting around to the review of the first chapter as promised. I talked about the book...
2010-06-07
799 reads
Get Index Details
We all know that indexes on tables help performance. However, sometimes too much indexing could affect performance as well. One...
2010-06-07
583 reads
Interactive Sort Order using Reporting Services 2008
Sorting results in a tabular style report is a common request from business users. Sometimes, they want to see the...
2010-06-07
842 reads
June 2010 S3OLV Meeting
The S3OLV monthly meeting is being held this Thursday. We will be meeting at the same location and time as...
2010-06-07
488 reads
Master Data Services
You need consistent, reliable data. You want data that you can trust.
This is usually data about your transactions, slowly changing...
2010-06-07
544 reads
Pensacola Holds Second Annual SQL Saturday
SQL Saturday #22 was held on Saturday, June 5, 2010, with about 224 attendees participating in this free event. It...
2010-06-07
1,087 reads
Professional Development Event:Taking Control of Your Career
This is just a reminder that this month’s Professional Development virtual chapter meeting we have MVP, PASS Board member, and...
2010-06-07
402 reads
StreamInsight
This is one of my favorite technologies for SQL Server 2008 R2. This session was from Torsten Grabs, the program...
2010-06-07
2,107 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 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...
The Large Encoded Value
Comments posted to this topic are about the item The Large Encoded Value
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