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.
Rodney landrum wonders what, if anything, you would do in SQL, or any other beloved technology, if you did not have to?
Learn dimensional modeling, cube design, MDX calculations and more in this 4 day online class from Pragmatic Works featuring BI expert Stacia Misner.
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.
This challenge is intended to calculate company's wage spent below a top level manager.
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 allows for two types of messaging activation, Internal Activation or External Activation. In this article we discuss External Activation.
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.
I had an hour spare this afternoon so I wanted to have another play with Reactive Extensions in .Net and StreamInsight. I also didn’t want to simply use a console window as a way of gathering events so I decided to use a windows form instead. The task I set myself was this. Whenever I click on my form I want to subscribe to the event and output its location to the console window and also the timestamp of the event.
SQLskills is offering a number of intense SQL Server training events later this year. A new class has been added in Chicago in May along with a London event in June.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
WhatsApp083179431638Jl. Pasar Baru 8, Lembang, Kec. Lembang, Kabupaten Bandung Barat, Jawa Barat 40391
Ruko Mega Grosir Cempaka Mas, Blk. A Jl. Letjen Suprapto No.5 A/7, Sumur Batu,...
Whatsapp:08218171955 Jl. Suryopranoto No.40, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus Ibukota...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers