How do you learn the advanced stuff?
Today Steve Jones talks about learning those advanced features that you don't get the chance to use in your daily work.
2011-10-04
328 reads
Editorials
Staying High
Today we have a guest editorial from Tim Mitchell. Tim talks about the need to stay motivated in your career after an event ends.
2011-10-03
108 reads
Closing Out Replies
This editorial was originally published on Oct 17, 2006. It is being republished as Steve is at SQLBits 9 today. Should we change the way we deal with posts and replies? Answer today.
2011-09-30
72 reads
What’s In Your (Junk) Drawers?
Today we have a guest editorial from Andy Warren. Andy talks today about he various items that collect around your work space. Are they useful? should you be cleaning things up? What does this say about you?
2011-09-29
115 reads
Bits Bound
Steve Jones talks about his trip to SQL Bits 9: Query Across the Mersey, which begins today.
2011-09-28
86 reads
Know when to hold 'em
It's time for the SQLServerCentral Party at PASS and Steve Jones talks about the event.
2011-09-27
78 reads
Probabilities and Disaster Recovery
Today Steve Jones talks about the probabilities of different types of disasters occurring in your enterprise. He reminds you that the effort spent on disaster recovery ought to be related to the cost of the disaster, and the risk of it actually occurring.
2011-09-26
215 reads
Where are all the MVBs?
Whereas there are plenty of experts prepared to help with the technology, few seem to come forward when the struggle is against the bureaucracy rather than a recalcitrant server. Where are all the SQL MVBs (Masters at Vanquishing Bureaucracy) when you need them!?
2011-09-26
136 reads
Big Gaps
Today Steve Jones talks about the gaps in our knowledge and our skill sets. He asks which things you think that all data professionals should be learning.
2011-09-23
362 reads
A Better Application Model
The AppStore model is one that Steve Jones likes, but he'd like to see it slightly more open over time and allow other companies to vet applications that users can then install on any system or device.
2011-09-22
103 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers