Category Archives: Microsoft SQL Server
-
Use BCP to create a CSV (comma delimited) file from a table.
1June 3, 2021 by Kenneth Fisher
This is a pretty handy little tool in your arsenal. I’ve talked about using bcp to transfer data from one …
Continue reading -
SQL Homework – June 2021 – SQL Audits
Leave a commentJune 1, 2021 by Kenneth Fisher
Last month I had you work on Extended Events, so hopefully now you are a bit more comfortable with them. …
Continue reading -
What account is xp_cmdshell using?
3May 25, 2021 by Kenneth Fisher
It works when I run it this way™ but not when I run it through xp_cmdshell! It’s a permissions issue. …
Continue reading -
#PowershellBasics: Writing to the screen
8May 20, 2021 by Kenneth Fisher
Writing to the screen is a really basic debugging technique. That said, since I’m really new with Powershell this is …
Continue reading -
Creating a configurable SSMS script
1May 18, 2021 by Kenneth Fisher
Several times over the last few weeks I’ve gotten a request to create a new work database. The individuals from …
Continue reading -
What do you do when technology changes? : T-SQL Tuesday #138
Leave a commentMay 11, 2021 by Kenneth Fisher
Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us to discuss how we handle changes …
Continue reading -
All jobs that ran during a given time frame.
2May 6, 2021 by Kenneth Fisher
Short post today. Simple query that will tell you every job that ran between two datetime stamps. Note: this of …
Continue reading -
SQL Homework – May 2021 – Extended Events.
4May 4, 2021 by Kenneth Fisher
You’ve probably heard about extended events right? I honestly don’t care if you are #teamProfiler or #teamXE you need to …
Continue reading -
Right sizing int : T-SQL Tuesday #136
4March 9, 2021 by Kenneth Fisher
Brent Ozar (blog|twitter) is our host this month, which will make this the most popular #tsql2sday to date I’m sure. …
Continue reading -
What is the CONTROL permission?
1January 19, 2021 by Kenneth Fisher
One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL: CONTROL: …
Continue reading
SQL Studies 