Using Parameters in #SQLPrompt
I am a big fan of snippets in SQL Prompt, often using them in demos to quickly get code written. However, I’ve liked the idea of snippets and templates...
2019-12-20
42 reads
The Voice of the DBA
Using a PoSh variable in a string- #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is something I haven’t quite understood or...
2019-12-18
96 reads
Unprepared for Travel
I’ve had a month off from travel, which has been nice. It’s been an interesting time catching up on things at home, and a nice break from the disruption...
2019-12-17
12 reads
A Smooth Laptop Setup
A little over a week ago, I got a new laptop. This was late on a Sunday afternoon, and I went home to spend time with me wife. After...
2019-12-16
212 reads
Prompt in ADS
Ever since VS Code and Azure Data Studio came out, people have been asking for SQL Prompt to port over. I’ve been right there with you, though unsure of...
2020-01-02 (first published: 2019-12-13)
244 reads
T-SQL Tuesday Gifts (#121)
It’s that time of month. I missed last month while traveling, but I wanted to get back in the party. This month, Mala has invited us to talk about...
2019-12-10
13 reads
Upgrading Windows 10 Home to Pro
I use Hyper-V and a few other things that require Windows 10 Pro. When I got my new laptop, it had Windows 10 home on it. Not a big...
2019-12-09
88 reads
HP is the 2019 Laptop Winner
This is for me, not necessarily for you, but I decided to go with the HP Spectre again. I saw an email from Best Buy over the Thanksgiving weekend,...
2019-12-06
44 reads
Resetting an Azure SQL Database Admin Password
This is likely something that most people know, but it was a bit confusing for me. This post is really here to remind me and help cement this in...
2019-12-18 (first published: 2019-12-05)
2,954 reads
A Quick Look at Travel
I was experimenting with visualizations the other day, and started playing with SandDance, a tool from Microsoft that you can use in Power BI or Azure Data Studio. I’ll...
2019-12-24 (first published: 2019-12-02)
284 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
how to calculate an average only if a minimum number of records exist?
Hi I am working on a rolling average calculation that is not working quite...
Subscribing to a Great New Year
Comments posted to this topic are about the item Subscribing to a Great New...
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers