|
|
|
|
Browse by Tags
All Tags » Database Admini... » SMO (RSS)
-
In my last blog post I walked through a way to grab the duration from the EnumHistory method of the JobServer/Job object. As I worked through getting a solution in place for a client I found that the duration calculation was only part of the problem. Read More...
|
-
Mark Freeman (@m60freeman) posted a question on Twitter using the #sqlhelp hashtag today, asking "Does anyone have a script to assign db_backupoperator for all databases in an instance to a login?" I looked and didn't really have anything that fit, but Read More...
|
-
Security is an important consideration when designing a database application. Who can get access to what data? How much damage can someone do if they get at your data? In SQL Server 2005 Microsoft implemented column-based encryption, and in SQL Server Read More...
|
-
Over time it's easy to lose track of the things you set up to get work done. As a consultant, I have to discover what's set up on a client system. In either case, it's important to know what security settings are in place to know if they're appropriate Read More...
|
-
Another quick check I like to do when in 'discovery mode' on a client system is to see what network protocols are enabled. Those of us around in 2003 will remember well the headaches caused by the SQL Slammer virus, and know to shut down Named Pipes unless Read More...
|
-
Lately I've been working on scripts to check and set security and configuration settings for SQL Server using PowerShell. One of the settings that I normally set and forget at install time is the Authentication Mode setting. Best practices suggest that Read More...
|
-
One of the great features of SQL Server 2008 is the FileStream data type. Paul Randal ( blog | twitter ) wrote a great white paper on it called FILESTREAM Storage in SQL Server 2008 . When you define a column to use the FileStream datatype SQL Server Read More...
|
-
This T-SQL Tuesday is about Automation in SQL Server, and I'll bet you think I'm going to talk about PowerShell. Well, you're partially right. What I'd like to talk about today, though, is setting up alerts to automate some responses to naturally occuring Read More...
|
-
This week I presented two sessions at the Fall 2010 SQL Connections conference, in Las Vegas, Automating Policy-Based Management Using PowerShell and Managing SQL Server System and Performance Data with PowerShell . I thorougly enjoyed doing both presentations Read More...
|
-
When you're trying to set up scripts to deploy policies to your servers (because you ALWAYS automate with PowerShell, right?), it can be sometimes difficult to determine exactly what facets are there, and when you do know the facet name, what properties Read More...
|
-
PowerShell is an amazing tool to help you automate your administrative processes. There are a lot of books and online sources to help you learn PowerShell, but how do you learn how to use it with SQL Server? Simple, just sign up for my PASS PreCon session. Read More...
|
-
I love the fact that you can get information about your SQL Server installations from SMO, and then you can use that information in scripts. This allows you to create one script for some function, like to create a database, for example, and run it on Read More...
|
-
I've recently completed a chapter for Paul Nielsen's SQL Server 2008 Bible on Scripting with PowerShell. While writing the chapter I created a short script to do a quick inventory of SQL Server information. Right after I wrote the chapter I was on a consulting Read More...
|
-
It can be tedious to keep a list of the version, edition or other information on each of the servers you manage. SMO provides an easy way to return this information, and PowerShell provides a quick way to get to SMO. Sometimes you may not know if a server Read More...
|
-
Last week I presented a session on Using SMO to Manage SQL Server at SQL Connections in Orlando, Florida. This was the third major conference I've presented this session, and each time I do this session I change more demos from VB.Net to PowerShell. This Read More...
|
|
|
|
|
|