SQL Server Everywhere: Just Another Database?
With the release of SQL Server Everywhere Edition looming, Scott sits down with Mark Jewett and Steve Lasker to find out about Microsoft's new database engine.
2007-04-13
4,161 reads
Articles
Advertising at SQLServerCentral.com
We're opening the newsletter up to advertising for everyone. Get the news here.
2007-04-11
1,199 reads
SQL Server 2005 Books
There have been a huge number of SQL Server 2005 books released in the last year, but which ones are worth buying? Here are reviews
of three new books from one of the SQL Server gurus.
2007-04-11
10,097 reads
Creating cross tab queries and pivot tables in SQL
For those times when you absolutely, positively got to perform a cross tab query in SQL, Keith Fletcher's T-SQL stored procedure will allow you to do it "on the fly". You can add it to your database and start cross tabbing immediately, without any further setup or changes to you SQL code. Check it out, and then take the cross tab challenge.
2007-04-11
4,992 reads
Sic Semper NULL
The great debate over NULLs will probably never end. Should we use them in our databases? What meaning do they have? These are all
valid questions. In this article SQL Server expert Michael Coles takes a look at the problems that are inherent in eliminating NULLs completely from
a database.
2007-04-10
5,991 reads
The NEWSEQUENTIALID Function
The NEWSEQUENTIALID system function is an addition to SQL Server 2005. It seeks to bring together, what used to be, conflicting requirements in SQL Server 2000; namely identity-level insert performance and globally unique values.
2007-04-10
2,884 reads
Take an Exam, get TechNet
If you are thinking of taking a SQL Server 2005 MCP exam, now is the time to do it. And with exam insurance, you can get two chances to pass and a free year of Technet!
2007-04-09
3,405 reads
Using Multiple Active Result Sets (MARS)
SQL Server 2005 has so many new features that in my opinion if you read only BOL for a year you'd find something new every day. One of those is Multiple Active Result Sets or MARS. Multiple Active Result Sets is a new SQL Server 2005 feature that, putting it simply, allows the user to run more than one SQL batch on an open connection at the same time.
2007-04-09
2,563 reads
Tracing Deadlocks
New Author! Deadlocks aren't the most common problem but they happen they can really degrade performance. Shiv works through how to nail down what is causing the deadlock.
2007-04-06 (first published: 2004-04-06)
44,288 reads
Twiddling the knobs: The Default Backup directory
What's the best way to change the default backup directory for a server, using SSMS or Enterprise Manager, without changing all the default directories at the same time? What is the TSQL to do it? A prize for the best correct solution.
2007-04-06
3,467 reads
Blogs
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Audit – Security Compliance Frameworks (Part 1)
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Forums
Alamat Kontak Bank BCA KCU MALANG Telp:08218154392
WA CS:08218154392 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur...
ALAMAT KANTOR BCA KCU PONTIANAK Telp:083831618008
WhatsApp:0838-3161-8008 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened
Comments posted to this topic are about the item Can You Really Downgrade from...
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers