Alter Table Not Permitted
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-10
683 reads
Gethyn Ellis
Dedicated Administrator Connection
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-09
689 reads
SQL Saturday Exeter
A couple weeks back was the second SQL Saturday to be held in Exeter. Although I wasn’t speaking this time,...
2014-04-07
570 reads
Backup and Housekeeping with Maintenance Plans
Get an idea of how to handle the housekeeping tasks associated with backups, like removing old backup and log files.
2014-02-17 (first published: 2011-01-26)
14,387 reads
SQL Server 2012 and Virtual Service Accounts
This post is written by David Postlethwaite
If you are using SQL Server 2012 you will probably have noticed that the...
2014-01-13
22,430 reads
SQL Server Training in London this Christmas
If you are thinking of upgrading to SQL Server 2012 in the near future then why not join me in...
2013-12-09
519 reads
Superfast Broadband – can be a drawn out slow and frustrating process
I’m writing this blog post to simply to vent some frustration. I live in Wales’ third largest city, Newport and...
2013-12-06
928 reads
Test Post – Please ignore
I’m just testng out my new laptop making sure things are working as they should
2013-11-18
479 reads
SQL Server Training Events–November and December 2013
I’m in New York City this week delivering a SQL Server Virtualization and Consolidation 3 days course for Learning Tree....
2013-10-29
700 reads
Job: SQL Server DBA (Permanent UK)
A client of mine are looking for a good SQL Server DBA on a permanent basis, the location is flexible...
2013-09-05
697 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
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
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