-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLStudies

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.

Archives: April 2018

SQL and Azure Maze

Something fun for the end of the month. Here are a handful of mazes for you to enjoy. I found them on http://www.printactivities.com/ which has a bunch of great resources for teachers (and bloggers looking for something fun/relaxing for their readers). Click on the images for larger versions of the… Read more

0 comments, 1,706 reads

Posted in SQLStudies on 30 April 2018

What is a DBA?

If you’ve worked in the data industry for more than few minutes then you’ve probably heard the phrase The DBA is dead or some variation on it. In fact, you’ve probably heard it more than once. It’s a common topic of conversation, for obvious reasons, and has been for a… Read more

0 comments, 259 reads

Posted in SQLStudies on 25 April 2018

Command shell steps in SQL Agent jobs only process a single command.

I was working on a SQL Agent job recently that required a series of command shell commands. And it would not work. Days I spent fighting it. I eventually went to sqlhelp. And while no one was able to give me an easy answer directly, Randolph West ( Read more

1 comments, 590 reads

Posted in SQLStudies on 23 April 2018

Exploring system tables, views, SPs etc

I wanted to spend a few minutes highlighting a couple of important tools for figuring out what information you have available to you within SQL Server. sys.all_objects and sys.all_columns. Note the All. These system views are almost exactly the same as sys.objects and sys.columns but with the single… Read more

0 comments, 850 reads

Posted in SQLStudies on 18 April 2018

I’ve gotten a transaction log full error but when I look it’s not full??

Every now and again I’ll get an error telling me a transaction log is full. This can be for any number of reasons (make sure you are taking log backups on your full recovery databases) but many of my co-workers (DBAs and others) get really confused when they check and… Read more

2 comments, 2,182 reads

Posted in SQLStudies on 16 April 2018

Deleting a lot of data

I recently had the task of deleting a bit over a billion rows from a table. Now I could have done just this:

DELETE FROM tablename WHERE createdate >= '1/1/2017'

But I have a few problems here. The table has no index on createdate, potentially causing problems with tempdb (the… Read more

5 comments, 1,923 reads

Posted in SQLStudies on 12 April 2018

Exploring permissions with sp_DBPermissions and sp_SrvPermissions : TSQL Tuesday 101

Our host for T-SQL Tuesday this month is Jens Vestergaard (b/t) and he has asked about our favorite SSMS tool. My initial thought was to talk about using solutions in SSMS but I’d already written about that. My next thought was to write about sp_DBPermissions and… Read more

1 comments, 228 reads

Posted in SQLStudies on 10 April 2018

SSMS’s Dark Theme

There has been talk of a dark theme for SSMS for years. Does it exist, will it exist? Well, the answers really are yes, and no. And by that I don’t mean yes and no as in maybe. I mean litterally, does it exist yes and will it exist… Read more

3 comments, 334 reads

Posted in SQLStudies on 4 April 2018

SQL Homework – April 2018 – Indexes

This month we are going to look at a topic near and dear to both database developers and database administrators alike. Indexes.

Even if you don’t actually do everything on this list right now (and it’s a lot) make sure you at least understand it all and are capable of… Read more

0 comments, 232 reads

Posted in SQLStudies on 2 April 2018