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?
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?
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.
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers