|
|
|
|
Browse by Tags
All Tags » SMO (RSS)
-
After a week of data recovery (see my blog post here ) and travel via train with no internet access, I've finally been able to get my presentation materials together from the Training Day and two regular sessions I did at SQL Bits #9 in Liverpool last Read More...
|
-
Other than changing planes once at Heathrow Airport, I've never been to England, so I'm getting really excited about traveling there next week for SQLBits 9 - Query across the Mersey ! My wife and I will be spending a couple of days in London first, and 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...
|
-
As a consultant I spend much of the first day or two at a client site discovering everything I can about their servers, before I start planning the engagement. You can find DDL triggers by going into the Object Explorer in Management Studio, open up each 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...
|
-
In a number of the PowerShell scripts I'm writing I have to build strings that contain the service account names or Active Directory group names for security principals used by SQL Server. PowerShell variables all start with the $ character, and many 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...
|
-
In conjunction with the launch of Red Gate's SQL Source Control product, I'm presenting a webinar on Thursday, November 18 at noon EST. I'll present an introduction to PowerShell for those who've never seen it, walk through the basics of the SQL Server Read More...
|
-
When you run a PowerShell script in a SQL Server Agent task (or JobStep, as the SMO object is called) I've figured out that when the step fails, Agent records the PowerShell error (as in what line in the script failed), but I've been sending my detailed Read More...
|
-
One of the things that Maintenance Plans do poorly is index maintenance. Unless you create your own scripts, the process simply rebuilds all the indexes in all the databases. This is one of the reasons why I really dislike maintenance plans. (My pre-con 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...
|
|
|
|
|
|