Security Regulations
There have been calls for governmental security regulations for IT. Is that a good thing? Steve Jones comments today.
2010-03-17
157 reads
Editorials
Stop, Don't Panic
Your response in a crisis situation can be critical to how quickly you solve the issue. Steve Jones reminds you to stay calm in today's editorial.
2010-03-16
162 reads
Database Documentation: Joining up the Dots
This week, a guest editorial from Phil Factor on how SQL Server database documentation falls woefully short of what is required and expected by most development teams.
2010-03-15
452 reads
The Corporate Borg
A new type of application looks to collate and integrate knowledge from workers all around a company. Steve Jones is reminded of the Borg for today's editorial and says it might be good for data professionals.
2010-03-15
218 reads
Friday Afternoon
This Friday's poll asks when types of distractions you might like to have at work that would let you recharge. Answer and let everyone else know what would help you enjoy your job more.
2010-03-12
132 reads
Separate Styles
Does it make sense to publish multiple articles on the same subject? Steve Jones talks about the reasoning behind how SQLServerCentral chooses content.
2010-03-11
135 reads
Code Writing Code
Do you write code that writes code? Steve Jones thinks this is one of those milestones that marks the maturity of a DBA.
2010-03-10
418 reads
Taking Advantage of SQL Server Tools
How many of you are taking full advantage of SQL Server tools? Brad McGehee thinks the answer is "Surprisingly few", and suggests you take the time to learn, and eventually master, the tools which already come with SQL Server.
2010-03-08
483 reads
Too Tipsy To Work
We all need time to relax and unwind, but what happens if that time is interrupted by a work call? Should you respond? Steve Jones reminds us that you can say no if you are not prepared to work.
2010-03-08
236 reads
SQLSaturday Bloopers
Traveling to Charlotte, NC for SQL Saturday #33, Steve Jones takes a break from writing with a short piece, and quite a few mistakes from this year.
2010-03-05
111 reads
Blogs
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
Forums
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...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
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