News

SQLServerCentral Editorial

Software Updates, Outages, Processes, and Protocols

  • Editorial

This past Thursday, February 22, AT&T had a major outage on their U.S. network. For upwards of 10 hours, hundreds of thousands of customers could not make phone calls, send or receive texts, or use mobile data for apps or browsing websites. Aside from not being able to communicate as normal, it also appeared to […]

You rated this post out of 5. Change rating

2024-02-24

111 reads

SQLServerCentral Article

Date and Time in SQL Server 2008

  • Article

SQL Server 2008 is well on its way to being complete and released with the release of the second CTP recently. There aren't a tremendous number of changes, but one of the more interesting ones is the changes to date and time handling in this new platform. The time and date datatypes have been separated and longtime SQL Server author Vincent Rainardi brings us a short look at how there can be used.

(32)

You rated this post out of 5. Change rating

2007-10-24

12,800 reads

SQLServerCentral Article

Passing a Table to a Stored Procedure

  • Article

SQL Server 2008, code named Katmai, has some very interesting additions to the SQL Server platform to make your development tasks easier. One of these is passing a table variable as a parameter to a stored procedure and regular columnist Jacob Sebastian shows us how.

(22)

You rated this post out of 5. Change rating

2009-02-13 (first published: )

34,316 reads

Blogs

“We love to debate minutiae”

By

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

By

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

By

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

Windows logins for users migrated from DomainA to DomainB

By a.koopman

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

By Kunal Rathi

Comments posted to this topic are about the item How to Use sqlpackage to...

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?  

See possible answers