Why You Should Volunteer for a Code Camp / SQL Saturday
This past weekend I was at the Columbia Code Camp, which was a rousing success with 6 tracks, a number...
2010-02-01
1,103 reads
Find Efficiencies or Add Horsepower?
In our world sometimes it’s worth the time and effort for in depth tuning to get the machine to run...
2010-02-01
667 reads
Sending SSIS Errors to the Windows Event Log
In a previous post I explained how to trap for errors in your Script Task and Components and send the information to the SSIS...
2010-02-01
4,781 reads
Teaching Two SQL Server 2008 Classes at University of Denver, University College in Spring Quarter
I’ll be teaching two SQL Server 2008 classes this spring at University of Denver, University College. The first one, which...
2010-02-01
779 reads
Stored Procedure to Sequentially Run SQL Agent Jobs
Introduction
Here is another one of my utility scripts. Lately it seems like all I am blogging about is utility scripts,...
2010-02-01
2,623 reads
Professional Association of SQL Server (PASS)
I recently discovered the Professional Association of SQL Server (PASS) virtual chapters. For those of you who struggle to make...
2010-01-31
2,029 reads
Interview Questions on Sql Server -Part 3
1. What are the Sql Joins?Sql Joins are the way to get data from many tables based on some logical...
2010-01-31
1,946 reads
Reading in 2009
I saw a blog post from my friend Paul Randal recently in which he recounted the books he’d read in...
2010-01-31
1,767 reads
Interview Questions On Sql Server -Part 2
1. What is the difference between the Union and Union All?
1) Union is used to select distinct data from the...
2010-01-31
2,003 reads
Interview Questions on sql server -Part-1
1. What is the Normalization?Normalization:-Normalization can be defined as the process of organization the data to reduce the redundant table...
2010-01-31
2,182 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
Alamat Kantor BCA KCU Galaxy Tlp:(08218154374)
WA CS 628218154374 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya,...
Alamat Kantor BCA KCU Malang Tlp:(08217555651)
WA CS 628217555651 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa...
Alamat Kantor BCA KCU Rungkut Tlp:(0817825533)
WA CS 628217825533 Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers