A New (and Hopefully Better) Approach to Constants
A look at how constants are used in T-SQL and SQL Server in general along with some suggestions on how better to deal with them.
The College Experience
We published an article about how one DBA goes about hiring new DBAs and in the discussion that followed there was something that caught my eye. There were a few comment talked about how college degrees don't necessarily mean anything.
Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4
This installment illustrates how to use PowerShell script to loop through the content of the file and connect to different servers.
Charlotte's SQL Server User Group
If you're in the Charlotte, NC area, the user group is meeting on October 16, 2007
The Pay Jump
Workers Rarely Jump Ship Over Pay Alone is an article that I saw awhile back and saved. It is 100% true and should be required reading by every C-level knucklehead and MBA student.
Who wants to be a SQL Server DBA?
A look at how one of our longtime members goes about hiring new DBAs.
Restore your SQL Server database using transaction logs
Most DBAs dread hearing that they need to restore a database to a point in time, especially if the database is a production database. However, knowing how to do this is of the utmost importance for a DBA's skill set. I'll walk you through the steps of how to restore a SQL Server database to a point in time to recover a data table.
Fun with Computers
The whole entertainment aspect of computing is growing tremendously and we're slowly seeing a convergence in our living rooms of computing capabilites along with entertainment. From rocker chairs with speakers to TiVo-type devices, the Nokia Internet Tablet, and XBOX 360s and Playstations that can enhance our movies.
Survive A SQL Server DBA Technical Interview
Another little bit of career advice, this time from longtime author Jeffrey Yao who gives you some pointeres on what you should know for your next job interview.
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers