Data Privacy and Protection Rebecca Edwards in Data Privacy and Protection Questions About HIPAA That You Were Too Shy to Ask As a data professional or developer, you will likely have questions about how HIPAA impacts you and your day to day responsibilities. Rebecca Edwards answers... 04 September 2018 8 min read
Database Administration Kathi Kellenberger in Database Administration Questions About Kerberos and SQL Server That You Were Too Shy to Ask Kerberos authentication is a topic that many database administrators avoid. It’s really not that difficult to understand, but it’s also easy to get wrong. In... 21 August 2018 12 min read
Opinion Pieces William Brewer in Opinion Pieces Questions About Data Breaches that You Were Too Shy to Ask News reports about data breaches are common occurrences. Even the companies that exist to keep our data safe are not immune. William Brewer answers the... 09 February 2018 16 min read
Opinion Pieces William Brewer in Opinion Pieces Questions about Data Governance that You Were Too Shy to Ask A company’s data is one of its most valuable and important resources. Managing and protecting that data are big responsibilities, and a data governance processes... 24 January 2018 16 min read
Opinion Pieces William Brewer in Opinion Pieces Questions about Data Masking That You Were Too Shy to Ask The General Data Protection Regulation (GDPR) will be in effect in May of 2018. Data masking is one technique that can help your organization comply... 30 November 2017 10 min read
Opinion Pieces William Brewer in Opinion Pieces Questions About the GDPR That You Were Too Shy to Ask The General Data Protection Regulation (GDPR) will affect organisations in countries around the world, not just those in Europe. The GDPR regulates how personal data... 14 November 2017 15 min read
Laerte Junior Questions About Amazon Data Migration Service (AWS DMS) That You Were Too Shy to Ask Can you imagine it? You are in a group of smart database people, and they are debating the finer points about AWS DMS, and you... 18 October 2017 9 min read
Laerte Junior Questions About RDS SQL Server That You Were Too Shy to Ask There are a number of different ways that you can host SQL Server. RDS SQL Server, for example, uses SQL Server within AWS as a... 13 September 2017 12 min read
T-SQL Programming Robert Sheldon in T-SQL Programming Questions About SQL Server Collations You Were Too Shy to Ask Of course we all like our colleagues to think that we know everything there is to know about SQL Server Collations. However, the truth is... 06 April 2017 29 min read
Database DevOps William Brewer in Database DevOps Questions About the Use of PowerShell That you were Too Shy to Ask Let's forget the actual PowerShell code for a moment: Why is PowerShell important? Why should I use it? Where did it come from? Why did... 12 December 2016 15 min read
Database DevOps William Brewer in Database DevOps Questions About SQL Server Security and Access Control You Were Too Shy to Ask For many developers, database security and Access control is just something that gets in the way of development work. However, several recent security breaches have... 04 November 2016 23 min read
Laerte Junior Questions About PowerShell Basics That You Were Too Shy To Ask Developers who are already familiar with application languages will be baffled by different aspects of PowerShell to the beginner to programming. Laerte recalls his initial... 11 April 2016 16 min read
William Brewer Questions About CUBE, ROLLUP and GROUPING SETs That You Were Too Shy to Ask There are few parts of SQL Syntax as familiar as the GROUP BY clause of the SELECT statement. On the other hand, CUBE and ROLLUP... 03 November 2015 17 min read
Adam Bertram Questions About Devops that IT Pros are Too Shy to Ask DevOps isn't a particular technology, nor a job role. It is more of a software development method, initiating originally from system administrators, that promotes ways... 29 June 2015 10 min read
Tony Davis Questions About SQL Server Transaction Log You Were Too Shy To Ask You can give a deep-dive presentation about SQL Server's transaction log, and round it off by inviting questions. Your audience will stare awkwardly at their... 11 February 2015 26 min read
Robert Sheldon Questions About T-SQL Control-of-Flow Language You Were Too Shy to Ask Surely, we all know how T-SQL Control-of-flow language works? In fact it is surprisingly easy to get caught out. What, for example, do the BREAK,... 26 January 2015 29 min read
Robert Sheldon Questions About Pivoting Data in SQL Server You Were Too Shy to Ask Of all the basic SQL operations, the pivot seems to cause the most problems. We can tell from the way that old articles on Simple-Talk... 01 January 2015 30 min read
Robert Sheldon Questions About T-SQL Transaction Isolation Levels You Were Too Shy to Ask Every time you access a relational database to make a query, you have an important decision to make: What is the appropriate isolation level for... 04 December 2014 28 min read
Robert Sheldon Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or linking to the spreadsheet as... 05 November 2014 31 min read
Robert Sheldon Questions about Primary and Foreign Keys You Were Too Shy to Ask It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without feeling embarrassed, yet nobody likes... 06 October 2014 36 min read
