SQL 2008 r2 version comparison
Comparison between Enterprise and Standard Versions of SQL 2008 R2
I’ve found myself recently trying to justify the need for Enterprise...
2010-06-03
10,136 reads
Blog Posts
T-SQL Tuesday coming next week
The T-SQL Tuesday party #7 is coming next Tuesday, June 8th. Since it’s TechEd week, and I’ll be there along...
2010-06-03
388 reads
Weekly Update - Internet Issues
I haven’t written anything technical or SQL Server related for that matter on my blog for a few of weeks....
2010-06-03
635 reads
Alternating Group Colors
Formatting reports can be a fun process. I personally look at myself as a Monet or Picasso when creating my...
2010-06-02
503 reads
Calculating ROI on Performance Tuning
Recently on the SSC forums, someone asked about how to measure the money in an actual dollar figure that they...
2010-06-02
741 reads
Daily SQL Server 2008 New Feature – Day 14
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-02
334 reads
Inventory SQL Servers with CLR Function
In an enterprise with several SQL Server instances it is pivotal that you keep track of each instance and its...
2010-06-02
723 reads
Speaking at SQL Saturday #22 - Pensacola, FL
If you are near Pensacola, FL this weekend, I will be speaking at their SQL Saturday on June 5th, 2010. I will...
2010-06-02
750 reads
SQL Server 2008 and 2008R2 Diagnostic Information Queries for June 2010
This version has updated build lists for SQL Server 2008 and 2008 R2. It also has several new queries, and...
2010-06-02
1,552 reads
Submitted Session Abstracts for PASS Summit 2010
I guess I will join the trend, and list the session abstracts that I submitted for PASS Summit 2010. There...
2010-06-02
895 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