It seems that we regularly hear about outages from various cloud services. Steve Jones comments that we are likely to have this happen more and more, but it's shouldn't happen at a rate greater than in house IT services.
2011-06-13
146 reads
If you’re not where you want to be in your career, then what do you think is holding you back?
2011-06-13
201 reads
This Friday Steve Jones asks you if you want more knobs for SQL Server or less? It's a debate that balances the need for the DBA to know more with the resources Microsoft spends to build better tuning into the product.
2011-06-10
91 reads
Today we have an editorial from Mar 22, 2006 as Steve is on vacation. Today Steve Jones notes that economics might determine how you are paid, but human nature describes how you behave.
2011-06-07
110 reads
Today we have an editorial reprinted from April 3, 2006 as Steve is on vacation. Ethics are often just as bad at the top of our companies as they are at the bottom. Steve Jones comments today on how this affects IT.
2011-06-06
103 reads
This week Steve Jones looks at a few notes that show employers are wising up overall about certifications and the value of real world skills.
2011-06-06
148 reads
Today we have an editorial from March 29, 006 as Steve is on vacation. Today Steve talks about the problems of constantly being distracted and not focusing on one thing.
2011-06-03
95 reads
Today we have a guest editorial from Chris O’Connor as Steve is on vacation. Today Chris talks about the responsibilities of application developers in safeguarding the data when there is no DBA.
2011-06-02
177 reads
Security is a big concern with data, especially when there is another company involved. Steve Jones notes today that cloud vendors need to beef up their work in this area.
2011-06-01
498 reads
Almost every DBA will be asked to change data in production at some point. Too often we don't have the tools to allow users to correct errors, but when you make changes, Steve Jones reminds you that you need to be careful and still have a process.
2011-05-31
231 reads
By Steve Jones
I was testing the new SSMS (v22 Preview 3) with Copilot and ran into...
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
Comments posted to this topic are about the item Create an HTML Report on...
Hi I have a SP that occasionally get this error: Cannot resolve the collation...
Hi everyone I am getting an error when I create the index but I...
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch in SQL Server 2022? See possible answers