A Lack of SQL
Steve Jones talks about a company looking to write all their stored procedures using the CLR in SQL Server. Is this a good idea?
2008-09-14
83 reads
Articles
Is it 1995?
A bug in the SQL Server 2008 upgrade process has Steve Jones questioning the coding practices at Microsoft.
2008-09-13
491 reads
Is it 1995?
A bug in the SQL Server 2008 upgrade process has Steve Jones questioning the coding practices at Microsoft.
2008-09-13
760 reads
Is it 1995?
A bug in the SQL Server 2008 upgrade process has Steve Jones questioning the coding practices at Microsoft.
2008-09-13
719 reads
Attribute Member Keys – Pt 1: Introduction and Simple Keys
Join Business Intelligence Architect Bill Pearson as he kicks off an exploration of Attribute Member Keys, a continuation of a body of articles surrounding significant components of the Analysis Services dimensional model. In this article we introduce Attribute Member Keys, focusing upon the simple keys and their properties.
2008-09-12
2,459 reads
Best Practices for Data Warehousing with SQL Server 2008
There is considerable evidence that successful data warehousing projects often produce a very high return on investment. Over the years a great deal of information has been collected about the factors that lead to a successful implementation versus an unsuccessful one. These are encapsulated here into a set of best practices, which are presented with particular reference to the features in SQL Server 2008.
2008-09-12
5,318 reads
2008-09-11
71 reads
Creating a Tabular Report - SQL School Video
SQL School continues with our series on Reporting services, this time examining how tabular reports can be easily built.
2008-09-11
4,940 reads
Patindex
This artcle by new author Manie Verster examines the use of the PATINDEX function in T-SQL.
2008-09-11
10,631 reads
Automatically Running Stored Procedures at SQL Server Startup
I have a stored procedure I want to run when SQL Server starts. Is there a way to execute this procedure automatically each time the SQL Server service is started?
2008-09-11
3,855 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers