Database Fundamentals #21: Using the JOIN Operator, OUTER JOIN
The OUTER JOIN returns one complete set of data and then the matching values from the other set. The syntax is basically the same as INNER JOIN but you…
Blog Posts
Indexed Views – Performance Panacea or Plight
An indexed view is a view where the result set from the query (the view definition) becomes materialized in lieu of the virtual table result set of a standard (non-indexed) view. Many…
Cool Stuff in Snowflake – Part 8: Time Travel
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to…
The Two Year Plan
Earlier this year as I thought about what I wanted to try in Orlando related to the SQL community and thought about the time commitment, I realized it was…
Notes from Orlando Code Camp 2019
Notes: Speaker party was well attended which makes it more interesting, the only downside was that the restaurant overall was LOUD, so much so that sometimes you’d have to…
Global AI Night at WSB in Chorzów
The 2nd of April 2019 was a big day because of the two global IT events. The one was for developers as a new Visual Studio 2019 was born….
SQLServerCentral Design Decisions–Forum Threads
It’s been a long couple of weeks. Almost two weeks ago we cut over from our older, v2 version of the site to the new (and current) v3. Lots…
Upgrading SQL Server on Linux
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance…
PASS Community And Mentorship
Mentorship is the influence, guidance, or direction given by a mentor as defined by Webster’s dictionary. I believe it involved a little more than that. It also involves investing…
Find Occurrences of a String Anywhere on an Instance
Oh, the dreaded string search (on an entire instance). What to do?
Blogs
Drop Database Objects Practically Risk-Free!
FIRST OF A TWO PART SERIES Some months ago, a fellow DBA came to...
Lengthen a Primary Key–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Setup SQL Server Alert to get automatically notified of database blockings
By SQLPals
Suppose you want to or need to know anytime your SQL Server is experiencing...
Forums
Protecting Data Between Services
Comments posted to this topic are about the item Protecting Data Between Services
SQL browser and port number
We have several new servers running SQL 2014. Some servers are single instance servers...
ssms crashes when editing .sql script
I’ve recently been having an issue with ssms freezing and crashing while editing a...
Ask SSC