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