SQL Server Installation Checklist
Many people have published SQL Server installation checklists before. Here is one I have been using for several installations without...
2014-04-01
15,118 reads
JR
Replication Agent Failure
I recently spent several days investigating a replication failure. Finding the answer specific to my problem was difficult, so I...
2011-08-08
6,468 reads
Poor man’s SQL monitor
Here is quick tip that can help you track SQL Job and Alert notifications in Microsoft Outlook. Many of you...
2011-06-20
887 reads
Managing Data Change
Often DBAs receive requests to manually manipulate production data. Ideally, all data changes should be performed through the appropriate application...
2011-05-20
1,861 reads
The First Post
I have been a SQL Server DBA and Developer for nearly ten years. In that time I have amassed a...
2011-05-05
431 reads
Blogs
How a new custom PowerPoint template is helping us to be more effective presenters
DCAC recently had a custom PowerPoint template built for us. We use PowerPoint for...
New Event Calendar
Speaking Engagements Check out my new Event Calendar, to see my upcoming and past...
Databricks Delta Lake
By James-Serra
Introduced in April 2019, Databricks Delta Lake is, in short, a transactional storage layer...
Forums
More Network Restrictions
Comments posted to this topic are about the item More Network Restrictions, which is...
SQL COUNT issue
I could use some help with the following COUNT issue. Select distinct Model_id, COUNT(CASE...
Finding out mismatch between time lines.
CREATE TABLE #Source ( PlanId BIGINT, StartDate DATE, EndDate DATE ) GO CREATE TABLE...
Ask SSC