Integration Services allows you to import all kinds of data easily into SQL Server as well as transform is along the way. Longtime author Paul Ibison brings us a look at how you should set your transformations to deal with NULL values.
Continuing on with his comprehensive series on XML, Jacob Sebastian shows us how to generate a tree of parent-child data using XML.
In Part 2 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.
Operational business intelligence is about delivering information to people when and how they need it in the context of business need. Explore the five best practices best-in-class companies are using to drive faster, better decision making and higher customer satisfaction.
Computed columns are an interesting way to cover some queries that might otherwise require a table scan. SQL Server expert Andy Warren brings us a look at this database design feature.
What is the page size in SQL Server 2005? That's an easy question, but what is the maximum row size? They're not the same thing and ANdy Warren shows you why.
One of our top posters and valuable member of the SQLServerCentral.com community weighs in on his absence.
Learn how to change a group of SQL Server stored procedures (SPs) that perform tasks in your databases. Edit SQL Server SPs at one time with these steps.
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers