Tag Archives: microsoft sql server
-
Restrict the usage of a SQL Server Authenticated Application Id
1December 6, 2017 by Kenneth Fisher
SQL Server login ids may not be the most secure thing in the world but they are likely to be …
Continue reading -
SQL Homework – December 2017 – View the log
3December 4, 2017 by Kenneth Fisher
Last homework of the year. Last month was to create a view. This month it’s time to take a look …
Continue reading -
Closing all of the connections to a database
4November 27, 2017 by Kenneth Fisher
Doing a database restore may not be the most common task a database professional will ever do, but it’s a …
Continue reading -
Why shouldn’t I shrink my database data file?
3November 20, 2017 by Kenneth Fisher
A while back I did a post about why you shouldn’t shrink your log file. This one is going to …
Continue reading -
Variables in Dynamic SQL
4November 16, 2017 by Kenneth Fisher
I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement. …
Continue reading -
It takes a village
1November 14, 2017 by Kenneth Fisher
Ewald Cress (b/t) is our host this month for Adam Machanic’s (b/t) monthly blog party T-SQL Tuesday. Having just gotten …
Continue reading -
More Collation Confusion. (tempdb)
1November 8, 2017 by Kenneth Fisher
I’ve talked about Collation Confusion before. We had the dev and test instances at one collation and the production instance …
Continue reading -
DBA Definitions: FILLFACTOR
1November 6, 2017 by Kenneth Fisher
It was recently brought to my attention that not everyone knows everything. This was a shock. Everyone is born knowing …
Continue reading -
SQL Homework Nov 2017: Create a view
3November 1, 2017 by Kenneth Fisher
Views are a highly useful tool for abstracting how you see the data stored in tables. At their simplest, they …
Continue reading -
Schema only backup or schema only DB copy
Leave a commentOctober 25, 2017 by Kenneth Fisher
Every now and again you have a database where you don’t necessarily need the data. It can easily be re-loaded …
Continue reading
SQL Studies 