Archives: January 2012
I needed to return an identity value recently from an insert for use in another piece of code. For a client front end, you can easily encapsulate your insert in a stored procedure and then SELECT scope_identity() to get the last identity. However there’s an easier way: the output clause. Read more
I wrote recently about capacity planning, with an item near the end about disk usage. Someone pointed out to me that compression can dramatically affect your baseline, and as you implement it, or de-implement it, you need to update your baseline.
That’s an important point, and if you make… Read more
One of the things that has been annoying for a long time in SQL Server is adding lots of data for testing. Personally I use Data Generator, and I recommend that, but for a quick few rows of data, do you want to do this:
CREATE TABLE SalesOrders ( OrderID…
I ran across this KB article the other day, which lists a few ways in which performance is affected by various maintenance or administrative type operations.
Google didn’t do the blackout I was hoping for, but they have hidden their logo:
I like the Wikipedia closure, which appeared seconds after hitting… Read more
Once again, I’m the moderator for a webinar coming up at the end of the month, on Jan 31, 2012. It starts at 11am EST, and features Brad McGehee (blog | @BradMcGehee and Grant Fritchey (blog | @gfritchey)talking about DBA administrative tasks.
I wrote a post recently on capacity planning, and then thought of one more thing. In addition to planning for the future for new systems, you also need to regularly monitor your existing ones.
Planning for the future, IMHO, isn’t something you want to do when you have a… Read more
A famous quote, and it’s one of the the most true quotes I’ve seen in my life. When someone has power, they develop a sense of importance, their decisions seem to be more “correct” and their arrogance grows.
It’s a sign of being human, and we have… Read more
Unlimited Vacation sounds good, and maybe it works, but I wonder how much vacation people really take at Red Frog. My guess is that it’s not far off from what most progressive companies give, something like 20 days a year.
It’s a good perk to have, and I’m sure… Read more
If you are unsure of what T-SQL Tuesday is, follow the link to this month’s topic to get the rules and description and then write a… Read more
I have a friend looking for a production DBA in Denver, so if you’re interested, email me at SQLServerCentral.
They need a production DBA in the South Denver area, backups, config, query tuning, replication, partitioning. SQL Server 2005-2008 R2.
Filed under: Blog Tagged: career, syndicated
I get asked this question a lot: When getting a new application and database, what kind of hardware do I need?
The answer is easy: it depends.
It depends on
- the load you will put on the SQL Server instance.
- on the SLA and performance numbers you need.
- the uptime…
I was writing a presentation recently on encryption and one of the important things to show in the presentation is the use of strong passwords. Many of the encryption functions will use passwords as an alternate way to secure keys, and I hate showing bad habits, like “mystrongpassword” in examples. Read more
I ran across a blog talking about Microsoft licensing, and found it very interesting. I learned a few things, and it’s a bookmark I’ll keep in mind.
A subtle change, one that caught my eye. In SQL Server 2012, if you don’t have Software Assurance, you have this limitation… Read more
I ran across a thread recently where someone was asking how to get the Windows start time from within SQL Server. Since SQL Server is a process running on the Windows host, I wasn’t sure how one would do this without running something like Uptime from xp_cmdshell. There was an… Read more
I received my fourth (or fifth?) renewal notice as a Microsoft MVP this morning. I am proud to be recognized as contributing to the SQL Server community. Thanks to everyone that reads my work or comes to see me speak and I’m glad if I can help a few of… Read more