Forgetful Databases
Chris Massey gives a speedy book review, discusses the erosion of data privacy in the so-called Digital Age, and considers the implications for DBAs of a possible solution.
Free Tools for the SQL Server DBA Part 2
After a very popular first article on tools for the DBA, David Bird is back with a list of some utilities you might find very handy for working with SQL Server.
Self-Service BI with PowerPivot for Excel 2010
Thiago kicks off a new series of articles, taking us through everything we need to know to use PowerPivot effectively. First off, he walks us through the prerequisites, and getting started with our first basic data set.
Sound Off with Soundex
In this article, learn how to use phonetic algorithms such as soundex to make looking up names faster, easier, and more reliable.
How Do You Handle the Stress of Being a DBA?
How do you deal with all the pressures, stress, and problems in being a DBA? Today we have a guest editorial from Brad McGehee that asks the question.
The power of batching Transactions
This article analyzes the performance gains of batching multiple DML statements into a single transaction. New author Manor Lev-Tov examines the effect of grouping statements together instead of running them all as separate transactions.
How To Enable Caching in SQL Server Reporting Services (SSRS)
We have many SQL Server Reporting Services (SSRS) reports that use our OLTP systems as data sources. We are always adding new reports and the number of users running these reports is also increasing rapidly. We would like to look at enabling report caching as a way to reduce some of the load on our database servers. In this tip I will go over the steps needed to enable report caching for SQL Server Reporting Services reports.
Help Others, Help Yourself
There is something to be said for helping others. However it isn't necessarily a selfless act. Guest writer Tim Mitchell talks a little about how helping others has helped him.
Retrieving Identities on set-based inserts
Learn a foolproof way to get identity values for multi-row inserts with the OUTPUT clause in SQL Server 2005 without using a cursor.
Full Text Index Queries using CONTAINS and CONTAINSTABLE
Recent installments of our SQL Server 2005 Express Edition series have been discussing its implementation of Full Text Indexing. This article focuses on the remaining two constructs, CONTAINS and CONTAINSTABLE.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Rahmadsyah Tlpn/wa:085373737551
Jl. Rahmadsyah No.140 - 142, Kotamatsum III, Kec. Medan Kota, Kota Medan, Sumatera Utara...
BCA KCU BUKIT BARISAN Tlpn/wa:085373737551
Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera Utara 20111
BCA KCP Juanda Medan Tlpn/wa:085373737551
Jl. Ir. H. Juanda No.28, Suka Damai, Kec. Medan Polonia, Kota Medan, Sumatera Utara...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers