T-SQL Tuesday #98 – Your Technical Challenges Conquered
Welcome to the January 2018 edition of T-SQL Tuesday and I am your host BlobEater (Arun Sirpal).
If you do not...
2018-01-02
626 reads
All About SQL
A Basic Bot using Azure Bot Services
I wanted to break out my comfort levels and do something different from Azure SQL Database or straight SQL Server....
2017-12-19
565 reads
SQL Server DBCC CHECKDB – Going Parallel
DBCC CHECKDB has the ability to perform parallel checking of objects. However, it absolutely depends on the edition of SQL...
2017-12-18
312 reads
SQL Server Failed to Open Loopback Connection – What?
I could not read my error log on one of my local SQL Servers, when I executed the following code:
EXEC...
2017-12-12
806 reads
Moving to an Azure SQL Database via Command Line
I have moved many databases to Azure via different methods but I recently came across a new way. Well technically...
2017-12-19 (first published: 2017-12-07)
1,520 reads
Azure SQL Database – Using sp_BlitzIndex
I was doing some normal activities on one of my Azure SQL Databases, I went to make a cup of...
2017-12-14 (first published: 2017-12-05)
1,689 reads
I have a new Passion
Yes, I like to blog, maybe slightly more on Azure than SQL Server. I enjoy it and it probably explains...
2017-11-28
353 reads
Azure SQL Database – Service Tiers
Naturally the cost of Azure SQL Database directly relates to what tier and performance level you are using. Starting from...
2017-11-23
484 reads
SQL Server – DBCC CHECKTABLE
If you know about DBCC CHECKDB then most likely you will know about DBCC CHECKTABLE. Quite simply this command performs...
2017-11-20
442 reads
Azure SQL Database Alerting
It’s good to be proactive and one way is to setup alerts and it is no different when using Azure...
2017-11-16
500 reads
Blogs
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...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
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