Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Explicitly using tempdb with ##tables

I had someone ask me last night if this statement would create a permanent table in tempdb with a strange name or a global temp table:

CREATE TABLE tempdb..##mytable
( id int
);

My suspicion was that this would always be a temp table, but since I usually don’t include… Read more

3 comments, 139 reads

Posted in The Voice of the DBA on 25 April 2016

Changing the sa Password with SQLCMD

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I wanted to make a quick note on changing the sa password, as this is a sensitive account, and the password should be changed if you ever… Read more

0 comments, 184 reads

Posted in The Voice of the DBA on 22 April 2016

Promotions and Conflicts of Interest

I noticed my co-worker, friend, and PASS board member, Grant Fritchey, posted a note on members of the PASS Board of Directors (BoD) presenting pre-cons at SQL Saturday events. It’s potentially a legal issue, and conflict of interest. I’m glad that the issue is being raised, and discussed publically. Here’s… Read more

4 comments, 183 reads

Posted in The Voice of the DBA on 21 April 2016

KDiff3

As I write more code, especially database code, and I collaborate with others (or myself), I find that I have the need to merge code more and more. It’s inevitable, and since I work across a couple machines, I even find that I need to merge my own code at… Read more

0 comments, 298 reads

Posted in The Voice of the DBA on 18 April 2016

Basic SQLCMD–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I had the need to connect from the command line recently, and decided to make a quick post on using SQLCMD, as I had an issue.

SQLCMD… Read more

4 comments, 203 reads

Posted in The Voice of the DBA on 14 April 2016

T-SQL Tuesday #77–My Favorite Feature

This month is an interesting, but tough topic. The blog party is hosted by Jens Vestergaard, and his invitation is short and simple. Pick your favorite feature and write about it. This is good, because SQL Server has grown so much, I’m sure that many people will choose different things.… Read more

0 comments, 178 reads

Posted in The Voice of the DBA on 12 April 2016

Changing the sa Password with SSMS–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I wanted to make a quick note on changing the sa password, as this is a sensitive account, and the password should be changed if you ever… Read more

0 comments, 1,123 reads

Posted in The Voice of the DBA on 11 April 2016

Win a SQLBits Pass

You can win a free conference pass to SQL Bits, in Liverpool, May 4-7. It’s easy, just post a review of one of their previous events. Haven’t been? No worries, post a review of a video of one of the sessions. You can find those here:

Read more

1 comments, 206 reads

Posted in The Voice of the DBA on 8 April 2016

MDF File Password Confusion

I had never seen this, but I ran across a blog that mentioned an MDF File password here. The post really looks at ways to reset the administrator password for the “sa” account in SQL Server. However it has some mistakes and issues. I tried leaving a comment, but… Read more

0 comments, 200 reads

Posted in The Voice of the DBA on 7 April 2016

Quick Encryption with Always Encrypted

What do you need to do in order to access data in a SQL Server that’s encrypted with Always Encrypted? It’s not much, and it’s really simple.

  1. The certificate used for encryption
  2. A parameter in the connection string

That’s it. It’s a small list of things.

I was experimenting with… Read more

0 comments, 304 reads

Posted in The Voice of the DBA on 6 April 2016

Locking sa

When I started working with SQL Server, the sa account was “the” account used for admin operations. This was the default account for many DBAs and as a result, it couldn’t be locked out.

This changed in SQL Server 2005, which is a good thing. We don’t want unlimited… Read more

0 comments, 220 reads

Posted in The Voice of the DBA on 4 April 2016

#SQLNewBlogger–Adding Local Accounts

 

What do you do if you need a process running under Local Service to connect to your SQL Server? Most of the advice out there is to change the login account. I actually agree with that, but there are times you can’t, or don’t want to.

There are certainly… Read more

0 comments, 172 reads

Posted in The Voice of the DBA on 4 April 2016

Protecting the SA Account

The sa account is a well, known, built in account for SQL Server. Years ago, in previous

versions, I’d see people often use the “sa” account for development, usually with a blank password. Even those speakers and experts often showed demo code with a blank “sa” password.

Ugh, a horrible… Read more

0 comments, 208 reads

Posted in The Voice of the DBA on 29 March 2016

SQL Nexus in Copenhagen

The Nordic SQLNexus conference is taking place in Copenhagen on May 2-4. I’ve never been to the event, or the country, but I was accepted to speak, so I embark on another multi-city, multi day trip.

SQLNexus has quite a lineup, and I suspect a few of these people will… Read more

0 comments, 164 reads

Posted in The Voice of the DBA on 28 March 2016

The OUPUT Clause in an INSERT–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I got asked a question about the OUTPUT clause recently and realized I didn’t remember the syntax. I’ve rarely used this, so I had to look it… Read more

3 comments, 1,635 reads

Posted in The Voice of the DBA on 23 March 2016

SQLBits in Space

It’s coming in May. The official UK SQL Server 2016 launch event is SQL Bits and the conference returns to Liverpool on May 4-7.  With a fun theme.

Check out the launch video here: SQLBits XV

Update (Mar 24): The agenda is live. I’m speaking Saturday at 2:30pm.

There… Read more

0 comments, 959 reads

Posted in The Voice of the DBA on 22 March 2016

SQL Data Generator –Specific Domains for a Column

I was mocking up some test data and wanted to limit my list of values to specific items. In this case, I was modeling the game, Rock Paper Scissors. In my modeling, I had a field for the value played by someone. In this case, I used a text… Read more

0 comments, 1,040 reads

Posted in The Voice of the DBA on 21 March 2016

What Database am I in?

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I saw someone trying to get the database context recently and they were confused. They had some code referencing @dbname, but received an error with this code.… Read more

0 comments, 221 reads

Posted in The Voice of the DBA on 17 March 2016

SQL Source Control v5.0 Beta–First Migration Script

I joined the beta program for SQL Source Control recently. I know, I work for Redgate, I should be in all beta programs. However I present on our various products, and I need those presentations  to work reliably. As a result, I rarely get ahead of our RTM products because… Read more

0 comments, 227 reads

Posted in The Voice of the DBA on 16 March 2016

Working on the Road

I spend a decent amount of time on the road, traveling to events. Last year I think I spent 50 nights in hotels for work. That’s a fair amount, and it can be challenging to get everything I need to accomplish done in those situations. I’ve gotten good at ensuring… Read more

2 comments, 222 reads

Posted in The Voice of the DBA on 15 March 2016

Older posts