Segments for Protection
Computer network security is important, and it's something we ought to be more concerned with as data professionals.
2019-06-18
105 reads
Editorials
SSMS or SSDT
The question this week deals with tools. Steve Jones is looking to see which tools are preferred by most database developers.
2019-06-17 (first published: 2015-03-27)
834 reads
Microsoft and Oracle Cloud Partnership
Many of us checked to make sure it wasn’t April Fools Day a couple of years ago when Microsoft announced that SQL Server 2017 would run on Linux. This means that some shops who want to run SQL Server, but not Windows Server, now can. But it also means that SQL Server professionals need to […]
2019-06-15
142 reads
2019-06-14 (first published: 2015-05-19)
535 reads
Upgrading Your OS
Windows 7 support is ending, but Microsoft doesn't have a good plan for home users. Steve notes that the OS upgrade treadmill ought to come to an end soon.
2019-06-13
141 reads
NOSQL and RDBMSs
NOSQL and RDBMS are evolving and absorbing ideas from each other. Is this necessarily a good thing? Perhaps we should think again
2019-06-12 (first published: 2015-08-27)
586 reads
Are We Suckers?
This week Steve Jones wonders if we work too much. Do we give more to our employers than they give to us?
2019-06-11 (first published: 2015-12-18)
553 reads
Setting Session Skill Levels
Kathi Kellenberger discusses the challenge of deciding how to describe the content in the sessions she presents.
2019-06-10
163 reads
Building or Buying Analytics
One of the decisions that I've been involved with at the beginning of every software project is whether to buy software to solve the problem or build our own. This might be a quick "is there software anyone knows about to do this?" query, or an in-depth review of the marketplace or something in between. […]
2019-06-08
139 reads
Microsoft Exercise
We have got a deal for you, Microsoft is concerned about the health of your company and is doing something about it.
2019-06-07 (first published: 2015-04-27)
523 reads
Blogs
Achieving application consistent recovery points of SQL Server 2008 R2 with Azure Site Recovery in Azure
If you want to use ASR to replicate SQL Server 2008 R2 standalone or...
Cool Stuff in Snowflake – Part 9: ILIKE
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud...
Scalar Valued Functions in SQL Server 2019
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
Database Mirroring Disconnect
I have noticed errors in the log cause mirroring disconnect and then few mins...
SSIS - Excel Connection with Week of Year timestamp - 1
Hello, I am working on an SSIS package as to which I would like...
Ask SSC