SQL Profanities
Do you avoid certain SQL functionality because you have been told you should NEVER use it?
2008-08-11
61 reads
Articles
SQL Server 2008: Table Valued Parameters
In SQL Server 2005 and earlier, it is not possible to pass a table variable as a parameter to a stored procedure. When multiple rows of data to SQL Server need to send multiple rows of data to SQL Server, developers either had to send one row at a time or come up with other workarounds to meet requirements. While a VB.Net developer recently informed me that there is a SQLBulkCopy object available in .Net to send multiple rows of data to SQL Server at once, the data still can not be passed to a stored proc.
2008-08-11
3,885 reads
The Starting Point
The Mojave Experiment is a marketing effort by Microsoft that is very interesting in looking at first impressions. Steve Jones comments.
2008-08-10
71 reads
The Starting Point
The Mojave Experiment is a marketing effort by Microsoft that is very interesting in looking at first impressions. Steve Jones comments.
2008-08-10
71 reads
The Starting Point
The Mojave Experiment is a marketing effort by Microsoft that is very interesting in looking at first impressions. Steve Jones comments.
2008-08-10
60 reads
MySQL Primer for the SQL Sever DBA
This is an introduction into Mysql for the SQL Server user. It compares the various engines of Mysql and how they compare to SQL Server.
2008-08-08
7,921 reads
Bill Baker - Database Weekly (Aug 11, 2008)
This weeks Database Weekly looks at a longtime leader for the Microsoft SQL Server development team leaving the company.
2008-08-08
62 reads
Bill Baker - Database Weekly (Aug 11, 2008)
This weeks Database Weekly looks at a longtime leader for the Microsoft SQL Server development team leaving the company.
2008-08-08
217 reads
Bill Baker - Database Weekly (Aug 11, 2008)
This weeks Database Weekly looks at a longtime leader for the Microsoft SQL Server development team leaving the company.
2008-08-08
233 reads
Mastering OLAP Reports: Parameterizing Number of “Top” Items with the MDX TopCount() Function, Part I
Writing high-performance reports against Analysis Services cubes means learning MDX to some extent. Parameterization of MDX functions is one of those things that cannot be delivered solely via graphical MDX Editor. BI Architect Bill Pearson demonstrates a way to parameterize the highly useful TopCount() function.
2008-08-08
1,846 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Designing for Teams
Comments posted to this topic are about the item Designing for Teams
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers