2021-02-16
5,205 reads
Blogs
Finally, a Universal Data Integration Utility
Earlier today, a revolutionary product was released: a universal data integration utility.
2015-04-01
6,687 reads
Time to Rebrand
I became a SQL guy back in 1998 because the company that hired me used SQL Server. It’s been a good ride and it’s paid the bills, but after 15 years or so it’s time to do something different.
2015-04-01
6,297 reads
Solid State Tapes–Prelaunch News!
In the world of data it’s always been about speed. SSD’s have become very common on consumer machines and not unusual in corporate datacenters.
2014-03-31
3,135 reads
Networking at the PASS Summit: First timers
The PASS Summit is just over a week away, and one again Andy Warren and I are hosting a networking dinner on Monday night. This is a free, informal event to help people get to know each other. Whether you are new to the community or have been to many events, you’re welcome to attend.
2013-10-14 (first published: 2013-10-04)
1,371 reads
Mo-SQL
If you’re involved in the database world it’s hard to have missed the rise of the “no-sql” database products, designed to – depending on your view or the product I suppose – make databases simpler, break out of the transaction database paradigm, scale out across hundreds of machines, make it easy to change the db design (or not require one). I think some of the problems no-sql tries to solve are real, others reflect a lack of awareness/training/tools on how and why relational databases could not just solve the problem, but solve it better.
2013-04-01
3,528 reads
Setup Alerts for PBM
PBM raises errors for policy violations. We can create alerts on those errors to be notified of policy violations. In order to setup alerts on these errors there are three prerequisites. Note that violations for the “On Demand” evaluation mode do not raise errors. A policy must be set to
2011-12-09
1,094 reads
Extended Events - inaccurate_cardinality_estimate
Extended events have been a bit of a personal “Elephant in the room” for me. I know they are there and I should really get on a start using them but never *quite* have a compelling enough reason.
2011-12-08
1,538 reads
First Day of Summit
My first day in Seattle has ended. My flight arrived around 12:30 and I was in good company with John Lang and Julie Smith on the same flight. We rode the light rail...
2011-10-12
642 reads
A SQL Server Hardware Nugget A Day – Day 7
For Day 7 of this series, I will talk about the incredibly useful CPU-Z utility, which is available for free...
2011-04-11
1,791 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers