CTE command In Sql Server
Common table expression (CTE):- Common table expression or CTE can be described as the temporary, named record set return by...
2012-01-17
4,984 reads
Blog Posts
Eliminating Successful Backup messages with Powershell and SMO
As a DBA, I enjoy knowing that the better job I do, the less likely it is that any of...
2012-01-17
938 reads
Error when creating a subscription
When creating a subscription in SQL Server sometimes the following error will occur:
The remote server "%s" does not exist, or...
2012-01-17
1,910 reads
Free SQL Performance Tool Worth Checking
First, I’d like to wish my readers a very safe, happy and prosperous 2012 (santé, properité, et bonheur). This is...
2012-01-17
1,626 reads
Goals – 6 month checkup
Last week’s resolutions post reminded me that it’s time for another status check on the goals I set for myself...
2012-01-17
823 reads
Hungarian Notation is misunderstood
Hungarian notation refers to a identifier naming convention. The variable indicates the variables use – as opposed to what they are....
2012-01-17
982 reads
Missing Indexes
SQL Server has means built into it to track possible missing indexes. This used to be found through the use...
2012-01-17 (first published: 2012-01-12)
3,840 reads
PASS Data Architecture VC presents: Audrey Hammonds–Database Makeover: Renovate Your Data Model
Subject: Database Makeover: Renovate Your Data Model
Start Time: Thursday, January 19, 2011 12:00 PM US Central Time (January 19, 2011...
2012-01-17
494 reads
SQLServerCentral Webinar #15
Once again, I’m the moderator for a webinar coming up at the end of the month, on Jan 31, 2012....
2012-01-17
824 reads
TOP WITH TIES
I have been working with SQL Server for quite a few years now, and it still happens quite often that...
2012-01-17
6,304 reads
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 Intercon Megah Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Komp.Intercom Megah, Jl. Joglo Raya Blok W-IV No.27, Srengseng, Kec. Kembangan, Kota Jakarta...
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers