Monthly Archives: April 2019
-
What do you get with a Free account in #Azure?
Leave a commentApril 29, 2019 by Kenneth Fisher
The first thing I want to do is say thank you to Michael Crump (b/t). He tweeted out this: What …
Continue reading -
Yes, pulling just the data you need is really important.
Leave a commentApril 24, 2019 by Kenneth Fisher
I was asked the other day why a customer was having performance issues on a table. A simple SELECT that …
Continue reading -
Shrinking a large database with limited outage windows
13April 22, 2019 by Kenneth Fisher
Yes, I realize you shouldn’t shrink your database (data files or log files), but I recently had a case where …
Continue reading -
It’s all just data.
2April 17, 2019 by Kenneth Fisher
Tables, stored procedures, views, logins, constraints, etc, etc. It’s all just data. In every database system I’ve ever worked on …
Continue reading -
How do I let someone execute a SQL Agent job they don’t own?
12April 15, 2019 by Kenneth Fisher
In my last post I discussed the fact that SQL Ids can, in fact, be useful on an instance that …
Continue reading -
Can SQL Ids be used on an instance with Windows Authentication only?
2April 11, 2019 by Kenneth Fisher
tl;dr; Yes, but. It’s generally considered more secure to have your SQL Server instance set to Windows Authentication and not …
Continue reading -
Writing Crossword puzzles with a database: T-SQL Tuesday #113
2April 9, 2019 by Kenneth Fisher
Todd Kleinhans (b/t) is host for T-SQL Tuesday this month and wants us to talk about how we use databases …
Continue reading -
SQL Homework – April 2019 – Practice dealing with corruption
Leave a commentApril 3, 2019 by Kenneth Fisher
Over the last almost 2 years (wow how time flys when you are having fun) we’ve practiced all kinds of …
Continue reading -
Making a life change
6April 1, 2019 by Kenneth Fisher
It is with a very heavy heart that I announce I will no longer be working with SQL Server. In …
Continue reading
SQL Studies 