Vertical filtering of a large replicated table introduces the potential for unwanted transactions to be pushed to the subscriber. This article talks about how you might avoid this.
2013-03-20
2,756 reads
I have a couple of databases supporting applications. The first application requires that it's user be a member of the db_owner role. The second application actually has to own the database. What are the effects of having such permissions? Check out this tip to learn more.
2013-03-20
4,108 reads
On Thursday March 21st 12PM noon Central, Steve Hughes will discuss Accounting for Windows Azure when looking at Data Architecture.
2013-03-19
2,692 reads
SQL Server's FileTable technology is an intriguing way of accomodating file-based text data in a database, and allowing for complex searches. The best way of learning FileTable is to try it out and experiment. Feodor shows how to set it up, add some sample data and set up full-text search.
2013-03-19
2,594 reads
This week Steve Jones talks encryption and why you shouldn't be implementing anything you've invented.
2013-03-18
191 reads
There are a number of challenges that make the deployment task more difficult. Alex reviews the common techniques for deploying new databases and upgrading existing ones, and their flaws, and argues the advantages of an automated, incremental, script-based approach to deployments.
2013-03-18
3,067 reads
Steve Jones and Grant Fritchey will be speaking at the SQL Intersection conference in April. Come join them in learning about SQL Server in the spring.
2013-03-18
1,777 reads
Jaap's Practical Guide to Exchange Server 2010 draws upon all that experience to deliver an easy-to-use guide to this latest platform, full of useful examples and top tips for SysAdmins, both new and experienced.
2013-03-15
1,138 reads
SQL Server Profiler can troubleshoot a wide range of SQL Server issues, such as poorly-performing queries, locking and blocking, excessive table/index scanning, and a lot more. Brad's book will allow you to master the use of this versatile tool.
2013-03-15
19,943 reads
Every day, out in the SQL Server forums, the same questions come up again and again: why is this query running slow? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed book on this essential topic.
2013-03-15
50,956 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. San Francisco Narogong - Cileungsi; No. 6 & 7, Limus Nunggal, Kec. Cileungsi,...
Jl. Insinyur H. Juanda No.54, RT.001/RW.001, Margahayu, Kec. Bekasi Tim., Kota Bks, Jawa Barat...
Ruko Cikarang Plaza, Jl. Yos Sudarso No.5 Blok B, RW.6, Cikarang, Kec. Cikarang 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