@ManyHatsDBA

SQL; SSIS; Sometimes DBA

 Cube
Joined October 2013
  • Tweets413
  • Following78
  • Followers65
18Media
Do you love seafood and #SQLFamily? Join us Friday after #PASSSummit at #CrabPot crabpot2024.eventbrite.com/?… #PASSDataCommunitySummit #PASSDataSummit
5
1
11
1,576
It took three years to finish, but our follow-up to the 2006 "What Goes Around Comes Around" is finally out! Stonebraker and I examine the last 20 years in databases and discuss why relational databases + SQL will continue to remain on top. 📄PDF: db.cs.cmu.edu/papers/2024/wh…
What Goes Around Comes Around… And Around… SIGMOD Record 2024

ALT What Goes Around Comes Around… And Around… SIGMOD Record 2024

23
332
68
1,254
173,183
So… anybody I know at pass?
24
I wrote a Suez sea shanty and I have no regrets
337
6,186
1,343
24,577
I’m thinking the Empire had a large number of contract Bothan DBAs....
1
They destroy a large sector of their IT infrastructure just before they suffer the loss of the second Death Star and the Emperor — and never recover control of their systems. But are forced to keep using them cause no time to rebuild and recover.
So, inherited a sql 2014 instance — if it’s running under the Local System account should NT Authority\system also have sysadmin? Instance has the everyone windows group as sysadmin and I want to start by disabling that — but don’t want to accidentally break things #sqlhelp
1
The feeling of horror when reading a sql server log and seeing “Setting database option RECOVERY to FULL” after setting it to Simple before a full backup.
2
This can’t help but make you smile
David Paxton
@DavidDPaxton7 May 2020
That’s top drawer Italianing.
Yesterday we buried a lovely woman. Due to #Covid19 there was no wake & our community couldn’t enter the church. But the entire parish came out & lined the 2km road to graveyard to say goodbye to Betty Ryan. Ar scáth a chéile a mhaireann na daoine #WestKerry
593
3,467
982
23,101
James King retweeted
Mike Judge
@MikeJudge20 Mar 2020
1,264
45,426
2,742
165,009
James King retweeted
Paul White@SQL_Kiwi1 Jul 2019
[Article] The ANY Aggregate is Broken. Two cases where the introduction of the internal ANY aggregate by the optimizer may cause wrong results: sqlperformance.com/2019/07/s… #SQLServer #SQLBlog #SQLPerformance

Some ANY Aggregate Transformations are Broken - SQLPerformance.com

Paul White explores two cases where the introduction of the internal ANY aggregate by the optimizer may cause wrong results.

sqlperformance.com
14
20
Anybody ever seen the error: security protocol not supported when creating a data source from ssrs to multidimensional analysis services? #sqlhelp
1
Well it turns out that it was because of some loop back guards on Windows.
It’s amazing that my fifteen month old, despite never having seen another kid reject their food, was immediately able to adopt the correct posture and facial expression to communicate that he wasn’t going to eat a bite. Ever.
1
The hockey gods are hard and cruel.
The NIH released a CloudFormation template so non-profits can deploy its REDCap clinical study infrastructure in the field. The template lets organizations deploy REDCap on AWS in 20 minutes with minimal technical know-how. I ❤️this. blog.executivebiz.com/2019/0…
1
8
1
32
Interesting: news.ycombinator.com/item?id… for anybody who does Agile(ish) development.
1
This is a fascinating discussion -- I wonder if you use a UTF collation in SQL Server if it's tied to an implementation in SQL Server, or tied to the OS implementation. postgresql.org/message-id/fl… A quick read of docs.microsoft.com/en-us/sql… seems to be that they are versioned on SQL
1
ht the hn article that pointed to this: news.ycombinator.com/item?id…
Load more