Flipping a Table Sideways
Not too often, someone asks for a strange request like wanting to pivot on every single value inside a table....
2010-05-28
1,585 reads
Blog Posts
Importing binary files with SSIS
I have gotten a number of emails over the past few days asking about how I import binary files into SSIS as well as how to improve throughput by...
2010-05-28
5 reads
Importing binary files with SSIS
I have gotten a number of emails over the past few days asking about how I import binary files into...
2010-05-28
2,489 reads
Importing binary files with SSIS
I have gotten a number of emails over the past few days asking about how I
import binary files into SSIS as well as how to improve throughput by...
2010-05-28
15 reads
New Unlocked CPUs From Intel
AnandTech has an interesting review up about some new models of Core i5 and Core i7 processors that are designed...
2010-05-28
1,450 reads
Permission Issue
I found a post of setting up database access in the following site and I responded there and I wanted...
2010-05-28
1,734 reads
The Truth about SQLPS and PowerShell V2
With the release of SQL Server 2008 R2 there have been claims that sqlps is really PowerShell V1 under the...
2010-05-28
5,528 reads
Two Blog Series You Don’t Want to Miss
Blogs are a great way to learn new things about SQL Server, and just in case you have missed them,...
2010-05-28
1,579 reads
Adding Space to a Home Server
I got new drives for my Windows Home Server the other day and decided to add some space to the...
2010-05-27
1,041 reads
Becoming a Part of the SQL Server Twitter Community
There have been tens of thousands of blog posts and articles written about Twitter, and because of this, I have...
2010-05-27
745 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