The 'bin packing' problem isn't just a fascination for computer scientists, but comes up in a whole range of real-world applications. It isn't that easy to come up with a practical, set oriented solution in SQL that gives a near-optimal result.
Learn how to build a CLR function that can be used to perform string manipulations that might be rather complex in T-SQL.
Steve Jones reminds us that our databases contain code, and as such, they ought to be under some type of version control.
If you are running an instance of SQL Server 2005 and above then most likely that instance is running the default trace. This default trace is a canned Profiler server side trace that automatically starts up when SQL Server starts. In this article Greg Larsen explains more about the default trace and shows you how to glean some event information from the trace files created by this background trace process.
This SSIS package generates XML invoice documents from data stored in SQL Server, then FTPs and/or Emails them to clients.
Today Steve Jones talks about his favorite feature in SSMS 2012 and why everyone should use it.
Red Gate Software has released Version 3.0 of SQL Monitor, a performance monitoring and alerting tool.
A free day of SQL Server training in Atlanta, GA on Apr 14, 2012. Sign up today if you will be in the area.
Wouldn't it be great if your HR folks only had to put in HR-SQL.mydomain.com for the database connection in their reports? They wouldn't have to remember it was on server Nile and they certainly wouldn't have to change their reports if you migrated their database from the Nile server to the server named Danube. In DNS there are two easy ways to do this.
This article describes the use and advantages of the throw statement.
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
Comments posted to this topic are about the item What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers