Sebastian is the SQL Stylist at sqlity.net llc - Guiding you to Readable, Maintainable, Error-Free & Fast T-SQL Code.

Joined December 2008
42 Photos and videos
Sebastian Meine retweeted
I don't see how a must-finish-N-stories "Sprint Goal" does anything at all useful for anybody, at least not if you have any pretense of agility. Everything from effort to "value" makes no difference. You won't know the value (or the effort) until after you deliver. ↓
10
18
142
21,071
Running tSQLt tests without the transaction is now possible. This allows for example testing of SSIS packages. It also allows you to shoot yourself in the foot. So, go gently.
9 Jan 2022
New tSQLt release published: V1.0.8043.39707 Release Notes: tsqlt.org/835/tsqlt-v1-0-804… Download: tsqlt.org/download/tsqlt/ Days since the last release: 94
1
7
17
Great session today. Loved everyone's questions at #PASSDataCommunitySummit. It seems a lot of people want to use #tSQLt on #AzureSQL DB. Let's upvote this @Microsoft feedback item: feedback.azure.com/d365commu…

1
3
#tSQLtLive is back with some more #tSQLt live coding on SpyProcedure for synonyms - Episode 3. Watch some TDD in #SQLServer happening in real-time and get your questions answered. Join us at 12:30 EDT here: youtu.be/hhZ7Ojm4P5g

1
1
2
#tSQLtLive is back with some more #tSQLt live coding on SpyProcedure for synonyms. Watch some TDD in #SQLServer happening in real-time and get your questions answered. Join us at 12:30 EDT here: youtu.be/UX5FJGJ8Ue0

1
1
We're working on an online training series about Data Platform #DevOps, UnitTesting, and #tSQLt for #SQLServer. The first class will be ready soon. Want to be notified when it's ready? → sqlity.net/en/tSQLt-training…
3
7
Come join me for some live coding with Dmitrij (github.com/dkultasev) on tSQLt tomorrow 10/15 at noon EDT: youtube.com/watch?v=ELfagpEr…
#sqlhelp, looking for a convincing article: I have 2 tables in 2 different DBs but with the same name (db1.dbo.tbl & db2.dbo.tbl). I also have an SSP db1.dbo.sp1 that SELECT * FROM dbo.tbl; When calling EXEC db1.dbo.sp1; while being connected to db2, which table is accessed?
2
The answer seems obvious, but I need some help convincing a friend.
Had to remove UFOs from the new dacpacs 🛸🛸
7 Oct 2021
New tSQLt release published: V1.0.7950.1808 Release Notes: tsqlt.org/824/tsqlt-v1-0-795… Download: tsqlt.org/download/tsqlt/ Days since the last release: 7
1
Sebastian Meine retweeted
4 Oct 2021
Confirmed: The DNS records that tell systems how to find Facebook.com or Instagram.com got withdrawn this morning from the global routing tables. Can you imagine working at FB right now, when your email no longer works & all your internal FB-based tools fail?

940
11,243
30,588
tSQLt now has an official DACPAC as part of the release. It also fixes a problem that many hand-created DACPACs had in the past. So, if you're using a DACPAC to include tSQLt in your projects, you definitely want to check this new release out. #tSQLt #sqlserver
29 Sep 2021
New tSQLt release published: V1.0.7942.19440 Release Notes: tsqlt.org/820/tsqlt-v1-0-794… Download: tsqlt.org/download/tsqlt/ Days since the last release: 259
1
3
Sebastian Meine retweeted
Data pros: what one feature do you look for when evaluating #DataOps tools or solutions to solve challenges in your database environments? #SolarWindsAdvocate
20% Improving data quality
37% Improve speed of delivery
37% Reducing workload
7% Controlling org dataflows
30 votes • Final results
1
3
4
hope to see you all again there (though virtual)
Reminder: #PASSDataCommunitySummit registration is now open & it's free to attend! Save your seat today and unlock unlimited access to 3 days of world-class training across #analytics, #architecture, #datamanagement, #development, #prodev, #DEI & more: ow.ly/8Vqi50FZuzk
2
3
Sign up for the free @PassDataSummit to see great speakers like @TracyBoggiano, Andy Yun (@SQLBek), @_AlexYates_, Monica Rathbun (@SQLEspresso), and many others. - I’ll be there too, talking about “Unit Testing with tSQLt”.
1
7
9
#NoteToSelf: Don't use backslashes for paths in Windows (at least if your "language" of choice is not the command line) - you may unintentionally escape characters like the string-ending quote
Sebastian Meine retweeted
As a... – user I want to... – change my password every 90 days so that... – in the event my password is compromised, my account will be safely protected. Well, eventually protected. Assuming the compromise wasn’t exploited immediately. Which it probably was. I'll just add a '1'.
10
291
1,563
Thinking about offering virtual office hours for #tSQLt to answer questions. Good idea?
50% What took you so long?
50% Can we not?
2 votes • Final results
2
5
Sebastian Meine retweeted
24 Mar 2021
I was going to write something longer on this, but I think I can summarise it in a line: Password only < password SMS < password authenticator app < password U2F vice.com/en/article/y3g8wb/h…

17
77
340
Sebastian Meine retweeted
Very impressed that @redgate has opened up PASS Pro learning for the community red-gate.com/hub/university/… And also the YouTube channel m.youtube.com/channel/UCCN1v… That’s brilliant and what I’d quietly hoped would happen. #sqlfamily - check out the content 😊
4
39