Dinosaur Databases
Do you work on a database system that's a dinosaur? A recent article called out RDBMSse as dinosaurs, but Steve Jones doesn't think that's correct.
I’m a SQL Server DBA, and I’m in Love with PowerShell
To learn PowerShell, Laerte Junior suggests that you just start using it. To encourage you to start, he provides a series of tips on using PowerShell with SQL Server to solve various everyday problems. With a little patience, a good IDE, and a bit of help and advice, "the lion is dead".
Late June 2010 PASS VC Presentations
PASS BI and DBA Virtual Chapters have free training available on Wednesday June 23rd.
Using the UPTIME Utility to Monitor Servers
Learn how to use a free utility to quickly monitor the uptime of your SQL Server instances.
Voting opens for Exceptional DBA of 2010
The voting for the 2010 Exceptional DBA opens today, and you can read about the finalists and prizes inside.
Making your SQL Server database changes backward compatible: Adding a new column
As multi-tier architectures grow over time, it is often challenging to coordinate those changes across the data, logic and presentation tiers. Unless planned and implemented carefully, an act as simple as adding a column to a table can grind all of the components of your application to a halt. While some of us have comfortable 12-hour maintenance windows every weekend, many of us are bound by service level agreements that are much more strict. So we must find ways to introduce fixes and new features with zero downtime, and without requiring every single component to be refactored at the same time.
Expert Systems – an SSRS Approach
An interesting approach to solving a complicated problem using SSRS. Users have too much documentation to read about a process, so Jonathan Spink introduces a better way to do things.
The Schema Debate
There was quite a bit of debate over the use of schemas recently on the Internet. Steve Jones talks about some of the reasons why you might want a schema, and a few reasons why you might not.
Creating XML in SQL Server
XML has become a common form of representing and exchanging data in today's information age. SQL Server introduced XML-centric capabilities in SQL Server 2000. That functionality has been expanded in later releases. One aspect of working with XML is creating XML from relational data, which is accomplished utilizing the FOR XML clause in SQL Server.
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 KCU KEBAYORAN BARU HUB Tlpn.0821•3111•185
BCA KCU KEBAYORAN BARU HUB Tlpn.0821•3111•185 Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela,...
BCA KCU BLOK A CIPETE HUB Tlpn.0821•3111•185
BCA KCU BLOK A CIPETE HUB Tlpn.0821•3111•185 Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5,...
BCA KCP Jalan Panjang TLP/WA 08216977749
Graha Elok Mas, Jl. Panjang No.79 EF, RT.6/RW.1, Kedoya Sel., Kec. Kb. Jeruk, Kota...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers