Throttle a Query in Mid-Execution
Resource Governor provides a great mechanism for throttling resources, but it doesn't always allow granular control. Read about this trace flag that allows you to dynamically alter the resource usage of a query.
Mo-SQL
If you’re involved in the database world it’s hard to have missed the rise of the “no-sql” database products, designed to – depending on your view or the product I suppose – make databases simpler, break out of the transaction database paradigm, scale out across hundreds of machines, make it easy to change the db design (or not require one). I think some of the problems no-sql tries to solve are real, others reflect a lack of awareness/training/tools on how and why relational databases could not just solve the problem, but solve it better.
TSQL Pivot Rotations using only REPLACE
Pivoting SQL Server tables is always awkward, even with the PIVOT and UNPIVOT operators. If you want to get the job done without GROUP BY or PIVOT, here is a way to do it using only REPLACE.
SQL Saturday #197 - Omaha
Join us on April 6th in Omaha for SQL Saturday #197. SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server.
The Command Shell
This Friday Steve Jones talks about xp_cmdshell and the security regarding its use. Do you have any holes that might exist if administrators are allowed to use this tool on their instances?
Using the SQL Server APP_NAME function to control stored procedure execution
In this tip we will look at one way to achieve control of stored procedures to ensure that reuse is for the intended purpose and changes do not break other applications that may be using this same code.
Halo 4 and Hadoop
A case study shows how the combination of Azure and Hadoop helped the Halo 4 team grow their successful franchise.
Re-throw Errors with Logging
This article brings you a technique and framework to use in your stored procedures that can allow you to re-throw and log errors.
Ad-Hoc XML File Querying
When you need to shred just part of the data within a large XML file into a SQL Server table, the most efficient way is to just select what you need via XQuery or by using XPath, before shredding it into a table. But precisely how would you do that?
HASHBYTES: Is CHECKSUM really required?
When compared with HASHBYTES, CHECKSUM, has a number of drawbacks. Hence, a question that comes up is: Is Checksum really required? In this article, I attempt to answer that question.
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
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...
Forums
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
ALAMAT KONTAK BCA KCP Katamso Telp:08218154393
WA:08218154393 Jl. Brigjen Katamso No.183, Keparakan, Kec. Mergangsan, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55121
ALAMAT BCA KCU SUBANG Telp:08218154393
WA:08218154393 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers