Social Software
More and more companies are looking to use social software, like Facebook, to link employees, but is this a good thing?
2008-03-27
181 reads
Editorial
Bad Automation
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
2008-03-26
107 reads
March Madness
How disruptive is the annual college basketball tournament to work? Steve Jones doesn't think it's a problem.
2008-03-25
52 reads
Feature (In)Complete
A look at some of the interesting database news from the previous week (March 24, 2008).
2008-03-24
202 reads
A Bad Report Card
The Federal Communications Commission doesn't get a good report on it's data handling and management processes.
2008-03-24
60 reads
Sharing
As humans we look to share with each other, but there are times that this can be a bad thing. Steve Jones has a poll asking you about your sharing habits.
2008-03-21
77 reads
Human Power
It's incredible what humans can accomplish when they work on a problem with passion. This editorial was originally published on Mar 20, 2008. It is being re-run as Steve is on vacation.
2012-11-19 (first published: 2008-03-20)
303 reads
Fire Drills
How often do you have those fire drills, testing what you would do in the event of an emergency. Would you be satisfied with a 30% success rate?
2008-03-19
91 reads
Get Rid of the Indexes
An idea that could save time and resources for backup and recovery in SQL Server.
2008-03-18
388 reads
SQL Server Data Services
SQL Server isn’t used much for web-based applications, simply because the cheapest ISPs use Linux and Apache for their platform. There are ISPs that provide a .NET platform and SQL Server but it is at a cost. SSDS seems to be Microsoft’s latest attempt to break into the market for database-driven websites.
2008-03-17
152 reads
Blogs
SQL Server Alerts
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
Prompt AI helping with Auditing
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Collation errors...what is best way to deal with it?
Hi I have a SP that occasionally get this error: Cannot resolve the collation...
Was the index created or not?
Hi everyone I am getting an error when I create the index but I...
Question of the Day
Estimated Rows
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch in SQL Server 2022? See possible answers