If you are in South Africa near East Rand, join the East Rand Developer and DBA group on April 9 for a presentation by SQL Server expert, MVP, and longtime SQLServerCentral author, Gail Shaw.
Today Steve Jones asks for your ideas on Microsoft's Connect. It's a good way to submit bugs and suggestions, but it seems to suffer from a scale problem. What do you think would help?
To finish this short series on extended properties a look at documenting sets of database objects
Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...
Come attend this free one day training event in Jacksonville, FL on Apr 30, 2011. Meet a number of SQL Server experts and learn about SQL Server at the University of North Florida.
What DBA wouldn't want to make their job a little easier?
Any DBA who has been bitten by these subtle data integrity issues, or reports that erratically produce the wrong results, will know how much careful testing is involved in mitigating them.
Describes different uses of the SSIS Foreach Loop container in one practical scenario.
What value can you place on data? It can be hard to determine, especially when so many sites on the Internet want data to be free. However the New York Times is going to a subscription model, with the idea that there is some value to their data and people will pay for it.
A SQL Server instance is set up to log the session start time and end time into a table. Given this table, your job is to find all time intervals in which no one is logged in.
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
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...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers