July Question: If you could pick your manager, what ideal qualities would he or she have?
I think all of us have had poor, good, and great managers at one time or another in our career....
2012-07-02
1,927 reads
I think all of us have had poor, good, and great managers at one time or another in our career....
2012-07-02
1,927 reads
Reprinted from my editorial in the Simple-Talk Newsletter.
It’s hard to believe, but it was five years ago that Red Gate Software...
2012-06-18 (first published: 2012-06-11)
2,043 reads
With the introduction of the instance-level option “optimize for ad hoc workloads” in SQL Server 2008, DBAs have a tool to deal with a problem known as plan cache pollution, or plan cache bloat. It’s often caused when one-time use ad hoc queries are sent to SQL Server from Object-Relational Mapping (ORM) solutions, such as LINQ, NHibernate, or Entity Framework. The problem can prevent SQL Server from using its available memory optimally, potentially hurting performance.
2012-06-14
2,478 reads
When I was a novice DBA, I spent little time documenting my SQL Servers. But as I became more experienced,...
2012-06-12 (first published: 2012-06-05)
4,734 reads
Dynamic Management Objects (DMVs and DMFs) are some of the most useful tools for the DBA. So this month’s question...
2012-06-01
1,027 reads
If you haven’t heard yet, Red Gate Software is sponsoring a six city tour of the United States of its...
2012-06-01 (first published: 2012-05-29)
1,779 reads
As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections...
2012-05-24 (first published: 2012-05-21)
2,170 reads
Forget what you thought you knew about SQL Server certification, as Microsoft has completely redesigned the SQL Server 2012 certification program, making is more difficult, costly, and time-consuming to attain.
2012-05-21
786 reads
Reprinted from my Database Weekly editorial.
Forget what you thought you knew about SQL Server certification, as Microsoft has completely redesigned...
2012-05-21
4,312 reads
I was just at SQLRally in Dallas, and I was speaking to a DBA friend of mine over lunch. He...
2012-05-14
1,025 reads
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
By Steve Jones
This image is from 2010, and it goes along with my last post of...
All week we've had issues with the site being up and down. There's been...
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers