Older Entries »

Security Audit on SQL Server 2008

By jscott, on October 22nd, 2011%

This week while I was working on Bolivia, I overheard the security staff discussing about options they can use to audit transactions done on the database tables. I interrupted and asked them if they knew about the SQL Audit configuration on SQL 2008, a… . . . → Read More: Security Audit on SQL Server 2008

Comments are closed   SQL Server, Technical

Security Audit on SQL Server 2008

By jscott, on October 22nd, 2011%

This week while I was working on Bolivia, I overheard the security staff discussing about options they can use to audit transactions done on the database tables. I interrupted and asked them if they knew about the SQL Audit configuration on SQL 2008, a… . . . → Read More: Security Audit on SQL Server 2008

Comments are closed   English, SQL Server

The SQL Database Consolidation Appliance

By jscott, on October 16th, 2011%

At PASS the SQL Server team annouced the first Database Consolidation & Private Cloud Appliance (http://blogs.technet.com/b/dataplatforminsider/archive/2011/10/13/announcing-the-first-database-consolidation-amp-private-cloud-appliance.aspx ) The ap… . . . → Read More: The SQL Database Consolidation Appliance

Comments are closed   Appliance, Consolidation Appliance, HP, Private Cloud, Server Appliances, SQL 2012, SQL Server, SQL Server 2012

The Secrets of PowerShell

By jscott, on October 5th, 2011%

PowerShell is one of Microsoft’s administrative task automation platform. It is designed to enable the management of all aspects of a Windows system. PowerShell provides a wealth of cmdlets, small programs that do useful things, e.g. getting a user … . . . → Read More: The Secrets of PowerShell

Comments are closed   PowerShell, SQL Server, Thomas Lee

Invoking (running) SQL Server Agent Jobs using PowerShell

By jscott, on October 3rd, 2011%

As I navigate the meandering thread of complexities that is the identity management project I inevitably find myself using SQL Server more and more.  Forgone is the text delimited management agent; embraced is the database management agent (specifical… . . . → Read More: Invoking (running) SQL Server Agent Jobs using PowerShell

Comments are closed   Example, PowerShell, PS, Script, scripting, sql, SQL Server, SQL Server Agent, Tip

SQL Server aliases

By jscott, on September 22nd, 2011%

(a.k.a. Honestly…My top Layer-8 issue of the year thus far) SQL Server aliases: they need to be created on all clients that use them, not just the SQL Server! How do we create them?  Two primary ways: CLICONFG.EXE (%systemroot%\system32\cliconfg). . . . → Read More: SQL Server aliases

Comments are closed   Example, Help, Layer-8, PowerShell, PS, Script, scripting, Setup, sql, SQL Server, Tip

To PowerShell or Not to PowerShell….?

By jscott, on September 16th, 2011%

Ever wonder if it's worth the bother to invest time in learning Powershell?  -“It’s safe to say that the single most important skill a Windows administrator will need in the coming years is proficiency with Windows PowerShell.”-   (TechNet… . . . → Read More: To PowerShell or Not to PowerShell….?

Comments are closed   Developer, Exchange Server, IIS, OS, SQL Server, windows server

Useful SQL PowerShell scripts

By jscott, on September 15th, 2011%

  Here are some useful PowerShell scripts that I use to evaluate customer’s SQL environments. They make no changes to anything but are useful for reporting and verification purposes and write the output to a file in a nice and clean tabular format…. . . . → Read More: Useful SQL PowerShell scripts

Comments are closed   PowerShell, SQL Server

Using Kerberos and Windows Authentication with SQL Server

By jscott, on September 6th, 2011%

In my opinion SQL or Windows Authentication isn’t a choice. You should always use Windows authentication unless technically impossible. The most common scenario is when the user account is not in the same domain as the SQL Instance and there is no tr… . . . → Read More: Using Kerberos and Windows Authentication with SQL Server

Comments are closed   SQL Server

BATCHman Uses PowerShell to Import a CSV File into His SQL Server

By jscott, on September 3rd, 2011%

Summary: Windows PowerShell superhero BATCHman quickly imports CSV data into his SQL Server.   Microsoft Scripting Guy Ed Wilson here. Sean Kearney is back today with Episode 6 of the BATCHman series. Note   You can read all gripping, engaging, info… . . . → Read More: BATCHman Uses PowerShell to Import a CSV File into His SQL Server

Comments are closed   BATCHman, databases, guest blogger, Scripting Guy!, SQL Server, Windows PowerShell
 
  Older Entries »

Categories

Archives

A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.