Stored procs vs user defined functions
I was at DevTeach/SQLTeach in Montreal last week. The conference was very well run and the organizers did a great...
2007-05-19
1,310 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
Conditional formatting in Reporting Services
Yesterday's post reminded me of another interesting technique I have used to change the color of the values on a...
2007-03-11
1,329 reads
Using IIF in Reporting Services
I found an interesting use for the IIF function in a Reporting Services report this week. I needed to provide...
2007-03-10
1,727 reads
SQL Server Learning Opportunities!
There are two big SQL Server learning opportunities I want to remind you about. First, DevTeach/SQLTeach will be held in...
2007-03-09
1,800 reads
Technology: Where have all the women gone?
Longtime author Kathi Kellenberger brings us a guest editorial today on what is happening with women in the technology world.
2007-02-12
154 reads
Phone books and Indexes
On Wednesday I gave a presentation to the St. Louis Visual Basic.Net user group. I really enjoy speaking to this...
2006-12-22
1,404 reads
SET QUOTED_IDENTIFIER
We recently received a script for a modified stored proc from a vendor. My colleague ran the script on the...
2006-12-15
2,576 reads
The Moto Q and Being Proactive
I am a big fan of automating whatever I can and being proactive. The more proactive you can be, the...
2006-12-14
1,517 reads
Joining Tables Part 1
In this video for beginners you'll begin to learn how to write queries that use more than one table using T-SQL. Kathi walks you through common tactics to efficiently pull out data from a normalized system.
2006-12-11
972 reads
Inserting missing rows
I can think of three ways to insert just the missing rows from one table or query into another table. ...
2006-12-06
3,050 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Alamat Bank BCA KCU SUDIRMAN TLP/Wa:0817839777
Hubungi Cs 0817839777 Jl. Jenderal Sudirman No.21, RT.10/RW.1, Kuningan, Karet Kuningan, Kecamatan Setiabudi, Kota...
Alamat Kantor BCA KCU SCBD Tlp/Wa:0817839777
Hubungi Cs 0817839777 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E,...
Alamat BCA KCU WAHID HASYIM Tlp/Wa:0817839777
Hubungi Cs 0817839777 Jl. K.H. Wahid Hasyim No.183 A-B, RT.14/RW.6, Kb. Kacang, Kecamatan Tanah...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers