I'm needing to audit the permissions in my databases, but I want to script them out so I have something to run in case of a recovery situation. I've got the logins, roles, and users handled, but it's the permissions that I want to extract. How can I do this easily?
2010-11-08
3,553 reads
In this next installment of his series on TDD, MVP Andy Leonard continues the development of his database.
2010-11-05 (first published: 2009-06-16)
16,645 reads
Your application code may look neat and clean, and you are using a sound Object-relational Mapper, but when you put the pedal to the metal, you're not getting the performance. The time has come to lift the hood and see what SQL is being generated by the ORM, and what part of your code is causing the bottlenecks. The effect can be spectacular.
2010-11-05
3,304 reads
Data structure virtualization is the constructing of a data structure utilizing pieces or fragments from other data structures. This article demonstrates how Data structure virtualization can be performed in ANSI SQL utilizing hierarchical processing techniques to produce hierarchically structured virtualized output.
2010-11-04
3,087 reads
In this next installment of the series on writing codeless applications, David Ziffer looks at the querying of data from the database.
2010-11-03
5,399 reads
Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use...
2010-11-03
1,706 reads
Fabiano introduces another ShowPlan operator that is used to build a query plan, or perform an operation specified in the DML. Once again, Fabiano demonstrates why it is important to be aware of these operators when getting queries to perform well.
2010-11-03
2,705 reads
Welcome to the second post of my “SQLBIGeek’s Function Friday” blog series. In this series, I am...
2010-11-03
1,111 reads
Learn to use recursion to determine which row caused your merge statement to fail in this article.
2010-11-02
16,663 reads
As your database grows in size, Analysis Services cubes that use that database grow along with it. As such, one...
2010-11-02
2,638 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...
Whatsapp:08216977726 Jl. TGH Zainnudin Abdul Madjid, Blk. A No.4, Dasan Lekong, Kec. Selong, Kabupaten...
Jl. Arjuna Utara No.Kav. 8 A, RW.1, Tj. Duren Sel., Kec. Grogol petamburan, Kota...
BCA KCP Kebon Sirih ?:0813•7887•595.Jl. Kebon Sirih No.6A Lantai 1 B, Gambir, Kecamatan Gambir,...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers