Database Health
What's in a database health report? Steve Jones asks what you might want to put in one for this Friday's poll.
SQL Server 2008 Data Collections and the Management Data Warehouse
Data Collections are a great tool that allows DBAs to gather different statistics, and the Management Data Warehouse (MDW) is the repository for storing those statistics. This article offers an overview of Data Collections and how to configure the MDW.
Understanding and dealing with orphaned users in a SQL Server database
Attaching and restoring databases from one server instance to another are common tasks executed by a DBA. After attaching or restoring of a database, previously created and configured logins in that database do not provide access. This tip looks at how to deal with this.
SQL Response Review - New SQL Server Monitoring Tool
Red Gate's SQL Response is advertised as a low-impact SQL Server monitoring application with an intuitive interface. Given the advertising, I signed up for the SQL Response Release Candidate and took a look. I was pleasantly surprised with what I found.
SQL Server PowerShell Extensions (SQLPSX) Part 2
In part two of his series on Codeplex extensions to Powershell for SQL Server, Chad Miller talks more about the functions in the project and how you can integrate with Reporting Services.
Take the Plunge
Today Steve Jones talks about starting your own business and should you do it with online tools.
Project Management Management
The state of project management for technology projects doesn't seem to be keeping up with technology itself. Steve Jones talks a little about what might be wrong.
Project Management Management
The state of project management for technology projects doesn't seem to be keeping up with technology itself. Steve Jones talks a little about what might be wrong.
Project Management Management
The state of project management for technology projects doesn't seem to be keeping up with technology itself. Steve Jones talks a little about what might be wrong.
SQL Server database design disasters: What not to do
Inspired by what he recently found in some SQL Server shops, database architect Brian Walker shares advice for improved database design – and SQL Server performance.
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 BLOK A CIPETE TLP:WA 08216977749
Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec. Cilandak, Kota Jakarta Selatan,...
BCA KCP GEMBLONGAN TLP/WA 083800209966
Jl. Gemblongan No.65 G, dan H, Kec. Bubutan, Surabaya, Jawa Timur 60175
BCA KCP Iskandar Muda II TLP:WA 08216977749
Jalan Sultan Iskandar Muda No.78 RT.003/05, RT.10/RW.2, Kby. Lama Sel., Kec. Kebayoran Lama, 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