Upgrading Your Career
Certification is on Steve Jones' mind this week after quite a few training opportunities have popped up lately.
How to Document and Configure SQL Server Instance Settings
There are around seventy SQL Server instance settings, and a DBA needs to be aware of the effect that many of them have. Brad McGehee explains them in enough detail to help with most common configuration problems, and suggests some best practices.
Behemoths of the server room: An interview with Glenn Berry
At the last PASS summit, we cornered SQL Server MVP Glenn Berry, and found out his views on the impact of virtualization, solid state disks and SAN administrators on the life of a DBA, and what led him to write a book all about SQL Server Hardware.
Encryption in Production
This Friday Steve Jones wants to know if you are using encryption in your production system and if so, how is it working? Can you handle DR situations?
Relational Databases and Solid State Memory: An Opportunity Squandered?
The relational model was devised long before computer hardware was able to deliver an RDBMS that could deliver a fully normalized database with no performance deficit. Now, with reliable SSDs falling in price, we can reap the benefits, instead of getting distracted by NOSQL with its doubtful compromise of 'eventual consistency'.
API Changes
Steve Jones comments on predictions that we will see new types of APIs coming in the future, especially data APIs.
Query accounts, domain groups, and members who have admin membership.
This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.
Learn about SQL Server 2012 in the desert
Come see Brad McGehee, Grant Fritchey, Steve Jones, and more SQL Server speakers at the SQL Server Connections conference in Las Vegas this spring. Get away from the cold on Mar 26, 2011 and learn about the new version of SQL Server.
SQL Server 2008 and 2008 R2 Integration Services - Sort Transformation
SQL Server 2008 R2 Integration Services offer a wide range of pre-built components, which deliver generic functionality commonly required when performing extraction, transformation, and loading tasks. While most of them are fairly straightforward to deploy in their basic form, typically there are refinements or caveats that should be taken into account as part of their implementation. This principle becomes quite evident when considering use cases of Sort transformation, which is the subject of this article.
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 Setiabudi Tlpn/wa:085373737551
Jl. Setia Budi No.150 A-B, Tj. Rejo, Kec. Medan Sunggal, Kota Medan, Sumatera Utara...
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
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