(Pinal Dave) If you work with a product for a long time, you would start loving it. I have worked with many other RDBMS, but my love to SQL Server will never die. The amount of information available in logs is very helpful and can help in pointing the exact issue related to retrieve data.
Tag: sql server
(Arun Sirpal) TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file too.
(Robert Sheldon) Analytics helps improve business operations, and SQL Server 2016 users can master it — in real time, using operational data in a transactional database.
(Chris Webb) As a consultant I frequently work with customers who want to add me to their Power BI tenant so I can publish reports, monitor data refresh and so on.
(Tim Wiseman) How can I incorporate logic similar to an If/Else construct into a T-SQL Query?
(Nakul Vachhrajani) Helping the community via forums often leads to some very interesting moments. Recently, I came across quite a common question – as part of a data migration, someone wanted to pad integers with zeroes. There are various variations to this question, namely:
(Grant Fritchey) In a previous post, I showed how to set up statistics maintenance for your Azure databases using Azure Automation. However, what I didn’t show was how to generate an alert when things go south. Let’s do that now.
(Steve Endow) I think I’ve been writing SQL statements since 1996. Maybe I encountered this scenario many years ago, but completely forgot about it. But I am pretty sure that since I have been working with GP over the last 13 years, I can’t remember ever encountering it.
(Pinal Dave) As a part of my passion, I try to help people in fixing simple issues and explain the behavior by looking at logs. Here is an email from my friend about Availability Group Missing or Deleted Automatically.
(Chris Webb) I first became aware of the server-wide lock taken out by SSAS when processing finishes – and the issues that this can cause – from this blog post by Andrew Calvett back in 2009.