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
75 reads
Editorials
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
88 reads
Get Rid of the Indexes
An idea that could save time and resources for backup and recovery in SQL Server.
2008-03-18
381 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
140 reads
2008-03-17
239 reads
2008-03-16
39 reads
2008-03-14
117 reads
Scaling Out
Scaling out is hard to do with SQL Server, but why doesn't Microsoft build a better solution?
2008-03-13
266 reads
The Social Contract
How much of a contract for servicing SQL Server should we expect? Has Microsoft broken an implied contract with us?
2008-03-11
85 reads
Bad Meetings
A joint editorial this week from the Red Gate team looking back at the news of the week.
2008-03-10
48 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
Issue with CPU Affinity Configuration on a SQL Server VM with 30 vCPUs
Hello , I'm having an issue with a SQL Server VM that has 30...
What is the best index strategy for a table that gets truncated?
Hi everyone My SSIS package does a bulk insert of csv files into a...
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers