The Business - Part 2
Today we have a guest editorial by Andy Warren. This one continues the thought of how you relate to the rest of your company, or "the business" as is it often known.
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...
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.
If you could stop working tomorrow, would you still do SQL?
Rodney landrum wonders what, if anything, you would do in SQL, or any other beloved technology, if you did not have to?
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.
Test Before Deciding
How do you decide what improvements to make to your SQL Server? Or what settings to turn off? Having hard and fast rules isn't a great idea, and Steve Jones talks about why.
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.
ANSI Connection Settings
It’s reasonably well known that you can get different execution plans if you change the ANSI connection settings. But the...
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.
Looking at SOX
This Friday Steve Jones asks what impact the Sarbanes-Oxley act has had on your job. After nearly a decade since the act was passed, is it intrusive in the workplace or just another part of your job.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Kemang CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Kemang Sel. No.60, RT.4/RW.2, Bangka, Kec. Mampang Prpt., Kota Jakarta...
BCA KCP Panglima Polim Raya CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec....
BCA KCP Pejaten CSTelpon : 0853-73737551
Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20 No. 98F & 98G,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers