2011-06-25
3,210 reads
Site Owners
2011-05-30
1,196 reads
Cartoonists Wanted
An open call to the amatuers that might want to pen some database related cartoons for Simple Talk Publishing.
2011-05-27
1,789 reads
Stairway to SQL Server Reporting Services
A series from MVP Jessica Moss designed to help you understand Reporting Services and begin building reports.
2011-02-09
3,908 reads
Stairway to Database Design
A series by Joe Celko that examines the craft of designing a database to meet your needs.
2010-12-06
12,873 reads
Decoding the SQL Server Index Structure
A deep dive into the implementation of indexes in SQL Server 2008 R2. This is information that you must know in order to tune your queries for optimum performance. Partial scans of indexes are now possible!
2010-04-01
8,142 reads
2009-11-04 (first published: 2009-10-16)
161 reads
The 2009 SQLServerCentral party at the PASS Summit
Get some details about the 2009 SQLServerCentral party at the PASS Summit in November.
2009-10-29 (first published: 2009-07-20)
2,173 reads
Murach’s ADO.NET 3.5, LINQ, and the Entity Framework with C# 2008
Read a sample chapter from this new book about C# and LINQ from Murach.
2009-08-11
2,285 reads
2009-07-09
25 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers