n a database I currently support, the application makes use of db_datareader and db_datawriter to give permissions to the tables. In a different database, it's even worse as the application uses db_owner. We're adding new tables to both databases and we don't want the application to have access to these tables. How can I deal with the use of these three roles?
2013-04-02
3,632 reads
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.
2013-04-01
6,515 reads
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.
2013-04-01
3,528 reads
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.
2013-04-01
6,173 reads
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.
2013-03-29
228 reads
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.
2013-03-29
4,280 reads
This article brings you a technique and framework to use in your stored procedures that can allow you to re-throw and log errors.
2013-03-28
6,023 reads
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?
2013-03-28
3,174 reads
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.
2013-03-27
8,233 reads
SQL Server Central’s Steve Jones and Red Gate’s Grant Fritchey will be among a stellar line-up of speakers at SQL Intersection conference in Las Vegas on the 8th to the 11th of April.
2013-03-27
154 reads
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...
Jl. Kota Baru 3 No.6, Petisah Tengah, Kec. Medan Petisah, Kota Medan, Sumatera Utara...
Jl. Setia Budi No.150 A-B, Tj. Rejo, Kec. Medan Sunggal, Kota Medan, Sumatera Utara...
Jl. Rahmadsyah No.140 - 142, Kotamatsum III, Kec. Medan Kota, Kota Medan, Sumatera Utara...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers