SQL Server Crossword #3
To mark my 30th Birthday today, as promised here’s a SQL Server Crossword for you to enjoy. You can find the previous...
2011-03-23
1,554 reads
Articles
Extracting Extended Properties
In this second article of a short series we look at using the Extended Properties which you have added to a database
2011-03-22
12,294 reads
SQL Server Central Webinar Series #8 - Source Control: Step One for Database Lifecycle Management
Join MVP Andy Leonard and Steve Jones in this webinar where you will learn how to get better control over your code and maintain versions using source control.
2011-03-22 (first published: 2011-03-10)
3,084 reads
Primary Keys – why accept the defaults.
G’day,
When I design a table in SQL SERVER, I like to have a reasonable understanding of how the table will...
2011-03-22
3,044 reads
Using Dynamic SQL in Stored Procedures
Dynamic SQL allows stored procedures to “write” or dynamically generate their SQL statements. The most common use case for dynamic SQL is stored procedures with optional parameters in the WHERE clause. These are typically called from reports or screens that have multiple, optional search criteria. This article describes how to write these types of stored procedures so they execute well and resist SQL injection attacks.
2011-03-22
7,301 reads
Pragmatic SSAS from BI expert Stacia Misner!
Learn dimensional modeling, cube design, MDX calculations and more in this 4 day online class from Pragmatic Works featuring BI expert Stacia Misner.
2011-03-21
1,329 reads
TSQL Challenge 52: Recursive Wage Calculation in a Parent-Child dimens
This challenge is intended to calculate company's wage spent below a top level manager.
2011-03-21
1,630 reads
ANSI Connection Settings
It’s reasonably well known that you can get different execution plans if you change the ANSI connection settings. But the...
2011-03-21
1,115 reads
SQL Server Service Broker - External Activation
SQL Server Service Broker allows for two types of messaging activation, Internal Activation or External Activation. In this article we discuss External Activation.
2011-03-21
2,453 reads
Mouse Clicks, Reactive Extensions and StreamInsight Mashup
I had an hour spare this afternoon so I wanted to have another play with Reactive Extensions in .Net and StreamInsight. I also didn’t want to simply use a console window as a way of gathering events so I decided to use a windows form instead. The task I set myself was this. Whenever I click on my form I want to subscribe to the event and output its location to the console window and also the timestamp of the event.
2011-03-18
2,408 reads
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCP Krekot Bunder TLP/WA 08216977701
Jl. Krekot Bunder Raya No.28, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat, Daerah...
BCA KCP Taman Palem Lestari TLP/WA 08218573837
By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV
Komp. Perum Jl. Taman Palem Lestari No.C5 No. 9 -11, Cengkareng Bar., Kecamatan Cengkareng,...
BCA KCU SUDIRMAN TLP/WA 08216977701
Jl. Jenderal Sudirman No.21, RT.10/RW.1, Kuningan, Karet Kuningan, Kecamatan Setiabudi, Kota Jakarta Selatan, Daerah...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers