3 Tips You Need To Know When Using PowerShell with SQL Server
Watch this week’s interview with Drew on YouTube.
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you’ve had...
2017-10-03
136 reads
Bert Wagner
3 Things I Wish I Knew When I Started Using Entity Framework
Coming from a SQL developer background these few inner workings of Entity Framework caught me by surprise.
2017-09-29 (first published: 2016-05-17)
7,949 reads
Clustered vs Nonclustered: Index Fundamentals You Need To Know
Photo by Patrick Tomasso on UnsplashHow many times have you known that adding an index would improve query performance but you weren’t exactly sure which type of...
2017-09-26
200 reads
How To Make Your Queries Perform Like They Used To
Photo by Chad Kirchoff on Unsplash
Prefer watching on YouTube?
In the ideal world, you fully test how your SQL Server will handle upgrading to...
2017-09-19
165 reads
Blogs
VSCode Tips–Remove the Highlighted Line
By Steve Jones
VSCode was making me crazy as I was writing a script. I like a...
Use T-SQL, not the GUI
By Jen McCown
There’s a very good reason to do most of your DBA work using T-SQL,...
Cloud Computing: Myths, Mysteries, Vampires & Vultures - a free seminar to help you learn more about "the cloud".
By Gethyn Ellis
To be honest you probably think that migrating to the cloud sounds great, and...
Forums
SQL Tamagotchi! Mini-Servers as Database Pets
Comments posted to this topic are about the item SQL Tamagotchi! Mini-Servers as Database...
SQL 2014 (or any other versions) Standard - ~Embedded Licensing~
Anyone have any insights on how this licensing works and what the "Use Rights"...
SSIS - Adding Columns to existing table and load data
I am working in SSIS (Sql server version 2012) , I have a requirement...
Ask SSC