Observe Carefully When Things Are Running Fine
Cross-posted from The Goal Keeping DBA blog:
As a worker in information technology, I’ve always been a big proponent of studying systems...
2013-01-14 (first published: 2013-01-10)
2,143 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Rename the SQL Server Management Studio shortcut
Jorge Segarra (blog | twitter) was giving a presentation and he remarked on how the SQL Server Management Studio shortcuts have...
2013-01-11
7,766 reads
Speaking at Midlands PASS in February
On February 12th I'll be giving a SQL Server Security Refresher for Midlands PASS at Microstaff IT in Cayce/West Columbia,...
2013-01-10
955 reads
Re-Awarded as a Microsoft MVP
Yesterday (January 1) I received the email indicating I was re-awarded as a Microsoft MVP, once again in SQL Server....
2013-01-02
1,185 reads
Looking Forward to the New Year - Professional Goals
Most folks make New Year's resolutions of things they want to do over the course of the next 364/365 days....
2013-01-01
1,298 reads
Are You a Chessplayer?
I was having a twitter coversation with @dataartisan about chess. He remarked that playing on-line with random folks didn't strike him...
2012-12-17
1,029 reads
Are Your Protecting Your DB Backups?
Folks have cited the recent InformationWeek article on how South Carolina's Department of Revenue was hacked because the SC state government...
2012-11-27
3,119 reads
Server Level Security
We'll discuss surface area later in the week. Today let's talk about if you're able to connect to SQL Server....
2012-11-09 (first published: 2012-11-06)
3,411 reads
SQL Server Security: The Sum of Its Parts
When it comes to attacking SQL Server, whether we're talking about the security of an installation or as a piece...
2012-11-05
1,459 reads
Preparing for Certification
One of my goals back when I was a young MCSE (that's Microsoft Certified System Engineer for NT4, not the...
2012-10-22
1,344 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
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...
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
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