T-SQL Tuesday #091 – Round-Up
Thank you to everyone who participated in T-SQL Tuesday #091 which was on databases and DevOps. As I anticipated, this...
2017-06-23 (first published: 2017-06-15)
1,708 reads
The Scary DBA
DevOps and Visual Studio
The hardest part about implementing DevOps is not the tools you choose, but the processes you use to make DevOps...
2017-06-13
1,120 reads
Database Fundamentals #2: SQL Server Management Studio
The best way to learn any software is to start using it. There are a bunch of software tools in...
2017-06-12
1,069 reads
T-SQL Tuesday #091 – Databases and DevOps
Implementing DevOps with databases presents a unique set of challenges. However, just because something might be hard doesn’t mean that...
2017-06-06
413 reads
Database Fundamentals #1: Install SQL Server
To get started with SQL Server, you need to install it. However, I’m not going to teach you how to...
2017-06-05
531 reads
Database Fundamentals
One of my favorite things about being a technologist is constantly learning new things, but, this can lead us to...
2017-06-15 (first published: 2017-05-31)
2,785 reads
Technology Gender Gap By State
This is my first ever guest blog post. Take it away Hazel Garcia.
Though the gender gap narrows by the year,...
2017-06-02 (first published: 2017-05-22)
1,417 reads
MySQL and Backups As A Service
With today’s announcement that MySQL is available as a Platform as a Service (PaaS) offering through Azure, a lot more...
2017-05-10
590 reads
General Notes on Security in Azure SQL Data Warehouse
I’m still learning about Azure SQL Data Warehouse (ADW, cause I’m lazy). ADW is a deceptively deep topic. Initially you...
2017-05-22 (first published: 2017-05-08)
1,160 reads
Redgate Alexa Contest Winners!
A couple of weeks ago we had a small contest here to pick a skill for Alexa. The entries were...
2017-05-05
476 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