Desired State Configuration for SQL Server – Configurations
In this tip we go through a real world configuration for using Desired State Configuration with SQL Server.
Biography
Shawn Melton started his IT career in 2002 after graduating college. He started working with SQL Server in 2005 and has worked with SQL Server 2000, 2005, 2008, and 2008 R2. He has been working as a full time DBA since 2009 in Montgomery, AL.
Community Activity
Shawn is a frequent contributor on Ask SSC and Stack Exchange forums helping out where he can with SQL Server and PowerShell questions.
SQL Server Interests
Shawn enjoys just working with SQL Server and sharing what he has learned with the community through blogging and contributing on forums. He has become interested in PowerShell as well and how it can be used both with SQL Server and other administrative tasks.
Shawn Melton started his IT career in 2002 after graduating college. He started working with SQL Server in 2005 and has worked with SQL Server 2000, 2005, 2008, and 2008 R2. He has been working as a full time DBA since 2009 in Montgomery, AL.
Community Activity
Shawn is a frequent contributor on Ask SSC and Stack Exchange forums helping out where he can with SQL Server and PowerShell questions.
SQL Server Interests
Shawn enjoys just working with SQL Server and sharing what he has learned with the community through blogging and contributing on forums. He has become interested in PowerShell as well and how it can be used both with SQL Server and other administrative tasks.
Internals of a Desired State Configuration (DSC) Resource
Learn about the internals of a Desired State Configuration (DSC) Resource to build your desired configuration.
Desired State Configuration and the SQL Server DBA
Read this tip to learn about how to automate tasks for SQL Server using Desired State Configuration.
PowerShell changes for database backups in SQL Server 2012
PowerShell has many features and one set of features is the ability to backup SQL Server databases. In this tip we look at PowerShell enhancments for SQL Server 2012 to backup SQL Server databases.
Using PowerShell for SQL Server Transaction Log Backups
How can I use PowerShell to do a Transaction Log backup for SQL Server databases? In this tip we look at an alternative way of creating transaction log backups using a PowerShell script.
Using PowerShell for SQL Server Database Backups
I have seen some of your SQL Server Backup tips. I am starting to learn PowerShell and want to see how I can use it for common DBA tasks. How can I create a basic PowerShell script to backup all my user databases? Check out this tip to learn more.
Why is SQL Server Configuration Manager Missing Services
When I open SQL Server Configuration Manager (SSCM) I see no services displayed (or just Integration Services). How can I resolve this quickly? Check out this tip for the solution.
What does my SQL Server data look like over the wire?
How can I see what the outgoing and incoming traffic to my SQL Server instance looks like? Are there any tools that can help with this? Check out this tip to learn more.
SQL Server Management Studio SQLCMD mode option
I recall in SQL Server 2005 Management Studio (SSMS) that I could quickly go into SQLCMD mode using a button on the SQL Editor toolbar. What happened to it in SSMS after SQL Server 2005, I can't find it? In this tip we walk through how to re-enable this
Using PowerShell to Pull SQL Server Services Configuration Information
Is there a way to pull information about the SQL Server services running on a server, without using SQL Server Configuration Manager? In this tip we look at how to use PowerShell to get this information.
Backing up SharePoint 2010 with SQL Server
What options are available to backup my data in a SharePoint 2010?