Tag Archives: microsoft sql server
-
Is it safe to grant Administer Bulk Operations?
4November 10, 2016 by Kenneth Fisher
First I guess we had best start with definitions right? The permission Administer Bulk Operations and the role bulkadmin are …
Continue reading -
New indexes, hypothetically
1November 2, 2016 by Kenneth Fisher
I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought …
Continue reading -
Synchronous vs Asynchronous
4October 24, 2016 by Kenneth Fisher
You’ll hear these terms thrown around in programming all the time, but what do they mean and why do we …
Continue reading -
Installing SQLCMD
2October 19, 2016 by Kenneth Fisher
For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says …
Continue reading -
Using Snippets
Leave a commentOctober 17, 2016 by Kenneth Fisher
A while ago I talked about Templates. This is an easy way to get a, well, template of a piece …
Continue reading -
Too many indexes!
6October 13, 2016 by Kenneth Fisher
Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work. Different indexes work …
Continue reading -
If backups are taken in silence can a recovery still take place?
3October 11, 2016 by Kenneth Fisher
My friend Andy Mallon (b/t) is hosting T-SQL Tuesday this month. In case you aren’t aware T-SQL Tuesday is a …
Continue reading -
Floor, Round, and Ceiling
5October 5, 2016 by Kenneth Fisher
I saw an interesting question today about rounding. Specifically they always wanted to round down. Now as it happens that …
Continue reading -
Becoming a Microsoft MVP
15October 3, 2016 by Kenneth Fisher
I was awarded the Microsoft MVP (data platform) award on Saturday. On the four days a year (one per quarter) …
Continue reading -
Pinned Tabs
5September 27, 2016 by Kenneth Fisher
It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b) …
Continue reading
SQL Studies 