After inheriting an existing SQL Server infrastructure, I've been working on improving my knowledge of database administration and Microsoft SQL..
I’m not alone with my most recent predicament. Through inheritance or bad luck, I'm an IT administrator that..
Keeping in line with Microsoft's initiatives to move more IT and database professionals to its cloud services, the company announced updates..
To enhance database communication security, all connections to a SQL Server database may be encrypted by using industry..
Microsoft announced early this morning that SQL Server 2014 has been released to manufacturing (RTM), and that general..
SharePoint can be complicated all in itself. But in many ways, SharePoint is just a web front end..
Update 2: 4/1/2014, 12:00pm MT - SQL Server 2014 is now generally available; added links to the SQL..
I recently needed to have an internal CentOS 6.x web server (LAMP-based) talk to one of our Microsoft..
SQL Server Integration Services (SSIS) is Microsoft's full feature extract-transform-load (ETL) tool in SQL Server 2005 and beyond. ..
Changing a job owner in SQL Server is relatively easy in SSMS and in T-SQL, but when you..
In the last article, PowerShell Basics for DBAs, we talked about how PowerShell is organized as a set..
As the DB field gets more mature and as DBAs become more seasoned, so do companies. So companies..
I teach PowerShell all over the place. I teach it at conferences, in webinars, in user groups, at..
In the last article, Scripting Database Objects in PowerShell, I showed you the basics of scripting your database objects..
One of the most important tasks a DBA can perform is to make sure he can recover from..