Moving Day
When you upgrade to a new server, there's more than just making sure that everything is ready to move, but do you clean house? Do you ever go back and ensure you're not moving things that you don't need?
Recursion with SQL Server 2008 within the Financial World
As most of you, we in the financial world have often been faced with the challenge of extracting data from relational sources that within the business frame of reference are more hierarchical in nature. Recently, I did what most of us do from time to.
Securing Reporting Services Data Sources
Marcin Policht continues his discussion of SQL Server 2005 Express Edition security related topics by describing functionality that facilitates protecting HTTP-based communication with the Reporting Services Web site by leveraging Secure Sockets Layer (SSL) encryption.
What happened to that email?
This question:
Created script to send mails using sp_send_dbmail- working like a charm.
Now searching for a way to get...
SQL Server Agent Jobs – Displaying Status in an Application
This article shows ways of getting feedback to your users when running a SQL Server agent job from an ASP.NET page
What Will I See at SQL Connections?
The SQL Connections conference will be held this November in Las Vegas and Steve Jones is attending. See what he's interested in viewing at the event.
Accommodating Null Values in SQL Server
The key to working with null values properly is to accommodate them consistently. Learn a few tricks that will help you do just that.
Migrating SQL Server Databases - The DBA's Checklist (Part 1)
Migrating a database is often a task fraught with complications, this series examines the key issues in a simple checklist.
Star Join Optimization in SQL Server 2008
When working with a dimensionally modeled data warehouse it is common for a large number of your queries to follow...
What Will I See at SQL Connections?
The SQL Connections conference will be held this November in Las Vegas and Steve Jones is attending. See what he's interested in viewing at the event.
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers