How to Improve MS Connect
If you haven't visited yet, MS Connect replaces the old sqlwish email alias and provides - in theory! - a better way...
2008-04-09
438 reads
Blog Posts
It's Over - SQL Server 2000 Support
Ok, I'm a bit of an ID10T at times.
I've talked about this for months, especially trying to push SP3 for...
2008-04-09
791 reads
Partitioning Gotcha
Well, it got me at least! Not long ago someone asked me about partitioned views and as I'm apt to...
2008-04-08
412 reads
SQL Server 2008 Management Studio
I made the decision today to start using SQL Server 2008 Management Studio at work to manage my 2000 and...
2008-04-08
812 reads
After Event Party Location Announced for SQLSaturday#3 in Jacksonville
From the SQLSaturday event site:
AFTER EVENT PARTY ANNOUNCED! Our after event party will be held at 7 Bridges Grille beginning...
2008-04-07
564 reads
Heroes Happen Here Charlotte, NC Launch Tomorrow (April 8, 2008)
The Heroes Happen Here launch event for Charlotte, NC is tomorrow. It looks like there are still registration slots open:
Heroes...
2008-04-07
1,007 reads
Link: April Fools Joke on Jonathan Schwarz of Sun
Absolutely worth watching.
http://blogs.sun.com/jonathan/entry/the_video
2008-04-07
516 reads
SQL Compare 7 Beta
Red Gate's schema comparison tool, SQL Compare, is in beta for the newest version, SQL Compare 7. You can find...
2008-04-07
1,197 reads
Thoughts on Database Mail
I suspect few would argue that database mail in SQL 2005 is a huge improvement over the mail system in...
2008-04-07
304 reads
A Note on sp_updatestats
In SQL 2000 when you run sp_updatestats it's the equivalent of running UPDATE STATISTICS on each table, forcing the update...
2008-04-06
416 reads
Blogs
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers