Using Windows PowerShell to get SQL Server connection information
Part 8 of our discussion on how to check SQL Server using Windows PowerShell examines how to get the SQL Server connection information.
2008-11-12
2,668 reads
Additional Articles
Reports for SQL Server 2008 System Data Collections
With SQL Server 2008's new Data Collection feature and the Management Data Warehouse (MDW), came three system Data Collection sets. This article covers the different data collection standard reports that have been provided to display information related to the statistics collected by the system data collections.
2008-11-11
2,517 reads
Using the FORFILES Command to Delete SQL Server Backups
Is there a way I can automate a file deletion process from within SQL Server?
2008-11-11
4,819 reads
CDC and Data Warehouse
The following article shows how Change Data Capture can be used to capture incremental data changes and use them in an ETL Process
2008-11-10
3,814 reads
Reviewing SQL Server Permissions
Permissions on data are one of the most critical aspects of database administration.
2008-11-10
3,072 reads
Auto generate restore scripts after each backup completes
There are a lot of scripts out there that will allow you to use the msdb to auto-generate restore scripts, but what if you cannot access the msdb database. What is the easiest way to make sure I have the proper restore scripts on hand without relying on the msdb database?
2008-11-07
3,562 reads
Migrating DTS Packages to Integration Services
In this whitepaper, you will see the benefits of migrating your SQL Server 2000 Data Transformation Services (DTS) packages to Integration Services by using two proven methods. You will also see how you can run and manage your current DTS packages inside of the SQL Server 2005 and 2008 management tools.
2008-11-07
5,110 reads
Exploring SQL 2005’s Ranking Functions – NTILE() and ROW_NUMBER()
Part 20 of the "SqlCredit – Developing a Complete SQL Server OLTP Database Project" examines SQL 2005’s NTILE() and ROW_NUMBER() Ranking Functions.
2008-11-06
4,328 reads
Operations Manager: A Big Tinker Set
To illustrate the great possibilities of Systems Center Operations Manager 2007, Thomas shows how to create a Custom Monitor for SQL Agent Jobs, and concludes that Operations Manager is nothing more than a big tinker set.
2008-11-06
2,392 reads
SQL Server Schema Binding and Indexed Views
How do you handle this error? "Cannot create index on view, because the view is not schema bound".
2008-11-05
3,263 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers