The sqlcmd utility in SQL Server
The sqlcmd utility in SQL Server is a handy tool for running ad hoc queries or creating script files to perform routine tasks or automate procedures.
2009-01-07
5,779 reads
Additional Articles
Conducting Service Broker Conversation Using Full Dialog Security in SQL Server 2005 Express Service
In the previous installment of our series covering the most relevant features of SQL Server 2005 Express Edition, we started an overview of Service Broker full dialog-level security. In this article, we will conclude this subject by describing the remaining prerequisites and a method to invoke a secure dialog.
2009-01-06
1,292 reads
Get SSAS Database Properties with PowerShell and AMO
Learn how to use Windows PowerShell and AMO to retrieve the database properties of SQL Server Analysis Service.
2009-01-05
2,063 reads
Graphical Execution Plans for Simple SQL Queries
Learning how to read and analyze execution plans takes time and effort. But once you gain some experience, you will find them an essential skill for getting to grips with performance issues in SQL Server Queries. Grant here describes the range of execution plans for different simple SQL Queries.
2009-01-05
5,326 reads
Kilimanjaro, Gemini and Madison - Get the lowdown
An interview with Herain Oberoi, group project manager for the SQL Server Business Intelligence and Data Warehouse product.
2009-01-02
2,872 reads
Data Quality and Data Profiling
David Loshin describes the benefits of the combination of the bottom-up aspects of data profiling with a top-down analysis phase for establishing criteria for data quality management.
2009-01-01
2,313 reads
Temporal Datatypes in SQL Server
In the first of a series of articles on the tricks of tackling temporal data in SQL, Joe Celko discusses SQL's temporal data types and agonizes over the fact that, although there are ANSI/ISO Standards for temporal operations in SQL, every vendor has something different.
2008-12-31
1,141 reads
Using Page Level Restore as a Disaster Recovery Procedure in SQL Server 2005
In a previous tip on Disaster Recovery Procedures in SQL Server 2005 Part 1, we have seen how we can come up with a disaster recovery procedure in SQL Server 2005. There are other ways to increase availability of your highly critical database in SQL Server 2005. What are those other options?
2008-12-31
2,725 reads
Database conversion between the most popular DBMSs
Today many companies determine to publish their data on the Internet trying to expand their business and make their information more accessible. The IT industry proposes a wide range of original solutions for resolving data inconsistency problems that publishers inescapably face when exporting their data as they need to properly access, process and interchange large amounts of information mainly through the web.
2008-12-30
2,236 reads
Proxy Accounts in SQL Server
Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them
2008-12-30
4,305 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers