The Voice of the DBA
Software Design and Schizophrenic Windows 8 Part 2
I know it’s not schizophrenic, but that sounds better. It’s really a split personality.
I wrote recently about Windows 8 and what I consider to be poor design in the update system. Today I want to look at another aspect that troubles me.
Programs
I’ve gotten used to the… Read more
0 comments, 102 reads
Posted in The Voice of the DBA on 17 May 2013
Not My Google Reader Replacement
Someone suggested Newsblur to me, and I went to their home page. Like many sites, it asks you to sign up, so I decided to give it a try.
The import from Google Reader caught my attention, so I clicked it. It asked for an authorization from Google, and then… Read more
1 comments, 153 reads
Posted in The Voice of the DBA on 15 May 2013
T-SQL Tuesday #42–The Long and Winding Road
It’s T-SQL Tuesday time, this month hosted by Wendy Pastrick who asks you to talk about the Long and Winding Road. Wendy asks us to talk about your job, your road map to the future, and what might be in store for you.
T-SQL Tuesday is a monthly blog… Read more
0 comments, 157 reads
Posted in The Voice of the DBA on 14 May 2013
Schizophrenic Windows 8
I’ve been using Windows 8 almost exclusively for about 3 weeks. I got a new desktop a couple months back, which has only had Windows 8 installed on it. My new laptop arrived about 4 weeks ago and a week later I finally abandoned my Macbook Air and moved fulltime… Read more
2 comments, 176 reads
Posted in The Voice of the DBA on 10 May 2013
Starting with Git for Database Development
One of the tools that Red Gate Software makes is SQL Source Control. It’s a plug in to SSMS that allows you to hook your database up to version control. I’ve used it a few times in the past in conjunction with Subversion to demo the product. However I hadn’t… Read more
1 comments, 628 reads
Posted in The Voice of the DBA on 8 May 2013
Donating for a little kid
One of my authors sent me this note:
“
I know you only know me as a writer for SQLServerCentral, but I have a friend whose son is really bad. He is at the hospital and the cannot pay it. It is very expensive. The family is desesperate. They live… Read more
2 comments, 92 reads
Posted in The Voice of the DBA on 6 May 2013
Adding Data to Filestream with T-SQL
I’ve written on how to enable Filestream and how to add a filegroup, but I haven’t touched the Filestream impact on your tables. This post will look at the table side of Filestream and how you get your binary data into the database.
Let’s assume you have a filestream… Read more
0 comments, 170 reads
Posted in The Voice of the DBA on 25 April 2013
Does TDE really work on MDF files?
Yes, it does. However, let’s prove it. First let’s create a database, a table, and enter some data:
-- create a database CREATE DATABASE TDE_Primer ; GO -- create and populate a table USE TDE_Primer go CREATE TABLE MyTable ( myid INT , myname VARCHAR(20) , mychar VARCHAR(200)…
1 comments, 1,348 reads
Posted in The Voice of the DBA on 22 April 2013
Doing Your Job
I wish this were the mantra of all people, but certainly those in technology:
Filed under: Blog Tagged: career, syndicated
1 comments, 223 reads
Posted in The Voice of the DBA on 19 April 2013
SQL Saturday #175–Fargo
One of the goals early on with SQL Saturday was to spread them far and wide. Andy Warren and I used to chat about how long it would be before we had 12 events in a year, or one event a month, or an event in every state. Karla Landrum… Read more
0 comments, 148 reads
Posted in The Voice of the DBA on 18 April 2013
Customizing SSMS–Results
This is a short series on some customizations in SSMS to make it visually more appealing.
As a presenter, I’ve learned how to change the way Management Studio (SSMS) looks to make it easier for people to see the screen on a projector. I had wrongly assumed that so many… Read more
2 comments, 116 reads
Posted in The Voice of the DBA on 15 April 2013
Disabling Resource Governor
I had known that the Resource Governor is always running in modern versions of SQL Server. It’s core to the operation of the SQLOS, though it can’t be used to do anything unless it is enabled.
You can read more about it if you have Enterprise Edition, and I’ve… Read more
0 comments, 213 reads
Posted in The Voice of the DBA on 8 April 2013
Thirty Hours at Home
This is a busy travel week for me, and one of those times that stresses out everyone in the household. I attended SQL Saturday #197 – Omaha over the weekend, arriving home Sunday morning from my trip. I had a good time at the event, my first time to Omaha,… Read more
0 comments, 141 reads
Posted in The Voice of the DBA on 8 April 2013
Reminders and Rehearsal
I’ve spoken at quite a few SQL Saturday events. I won’t hit 50 this year, like Kevin Boles, but by my count, I’ve been to 21, with 4 or 5 more coming this year. I have no idea when I’ll get to 50, but I hope I do.
That’s… Read more
0 comments, 176 reads
Posted in The Voice of the DBA on 2 April 2013
The Great Laptop Search of 2013
It’s time for a new laptop. I don’t think it’s time, as I love the Macbook Air I bought a couple years ago. Rather some requirements for work, mainly Hyper-V, have come up and I can’t meet them with the Macbook Air. Even a 2013 summer refresh of this platform… Read more
10 comments, 1,995 reads
Posted in The Voice of the DBA on 28 March 2013
The DBA Team #1–Code and Slides
Our first DBA Team event, in Richmond, VA just before SQL Saturday #187 went well. Overall I think our experiment was a success and we’re already talking about where and when we might do this again.
In the meantime, we didn’t make a separate site for this series of events,… Read more
2 comments, 314 reads
Posted in The Voice of the DBA on 27 March 2013
SQL Saturday #187–Richmond Recap
I’m late writing this, and I did mean to get to it earlier, but life got in the way.
TL;DR: It was a great event, lots of fun, and I’d love to do it again.
When I first heard of a SQL Saturday coming back to Richmond (from Carlos Chacon Read more
2 comments, 171 reads
Posted in The Voice of the DBA on 26 March 2013
A Week from Omaha–SQL Saturday #197
Next week I head out to SQL Saturday #197 in Omaha NE. I’m looking forward to it as I’ve never been to Omaha, and only been to the state once, in the far SW corner to Oshkosh for a horse race. I’ll arrive Friday and have a short time to… Read more
0 comments, 206 reads
Posted in The Voice of the DBA on 25 March 2013
Macbook Air v Surface Pro
I love my MacBook Air. It’s small, light, and it works well as a traveling laptop for me. It starts and stops instantly, and the only complaint I have is that my 2011 version only has 4GB of RAM and no USB 3.0. The 2012 version improves, and I’d upgrade,… Read more
0 comments, 358 reads
Posted in The Voice of the DBA on 22 March 2013
Customizing SSMS – Bigger Queries
This is a short series on some customizations in SSMS to make it visually more appealing.
As a presenter, I’ve learned how to change the way Management Studio (SSMS) looks to make it easier for people to see the screen on a projector. I had wrongly assumed that so many… Read more
0 comments, 360 reads
Posted in The Voice of the DBA on 21 March 2013



Subscribe to this blog