Why you *can't* provide your Facebook credentials
I know this isn't related to SQL Server, but it is related to security and privacy.
If an employer or...
2012-04-02
2,388 reads
Databases – Infrastructure – Security
T-SQL Tuesday #028 - I'm a Jack of All Trades, and Proud of It
If I wasn't, would I have proposed the following topic for several speaking chances, including SQLRally?
Being a specialist means you're...
2012-03-13
1,457 reads
SQL Saturday #110 - Tampa - The Dirty Business of Auditing Presentation Materials
For those who might want the materials for my presentation at SQL Saturday #110, I've posted them to the site.
SQL...
2012-03-10
1,051 reads
SC Midlands Chapter of ISACA - SQL Server Auditing Course Materials
If you attended my SQL Server Auditing course held for the SC Midlands Chapter of ISACA, I finally was able...
2012-03-09
1,331 reads
T-SQL Tuesday #028 - I'm a Jack of All Trades, and Proud of It
If I wasn't, would I have proposed the following topic for several speaking chances, including SQLRally?
Being a specialist means you're...
2012-03-06
1,226 reads
Speaking at oPASS on March 8th
I will be at oPASS on March 8th (Thursday) in Orlando, Florida. I'll give a preview of the talk I'm giving...
2012-03-01
1,030 reads
Presenting Two Sessions at SQLRally
I just received great news that one of my sessions, Attacking SQL Server, was picked by the community for SQLRally....
2012-02-27
979 reads
New Article: Exploiting SQL Server via CONTROL SERVER permissions
I have a new article up at MSSQLTips.com, covering what someone can do with CONTROL SERVER. Most folks know to...
2012-02-27
1,734 reads
A Plea: Have your guidance documentation reviewed
Today one of my auditors sent me her matrix for auditing Microsoft SQL Server. I had seen part of it...
2012-02-23
1,229 reads
Two Sessions Up for Vote at SQLRally!
I received great news last week that one of my sessions, Windows Operating System Internals for DB Pros, was accepted,...
2012-02-21
856 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