What are the database and technology questions you’re simply too shy to ask?

Whether you’re confused about SQL Server foreign keys, curious about data security, or just want to know everything about T-SQL expressions, Simple Talk has you covered…

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…

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…

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…

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,…

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…

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…

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…

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…

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…

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…

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,…

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…

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…

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…

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…

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,…

26 January 2015 29 min read

Robert Sheldon

SQL Server PIVOT: 12 Questions Answered (Multi-Column, Dynamic, UNPIVOT)

Twelve answered questions about the SQL Server PIVOT operator: how PIVOT rotates data, controlling grouping, column aliases, multi-column pivots, dynamic…

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…

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…

05 November 2014 31 min read

Robert Sheldon

Questions about SQL Server 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…

06 October 2014 37 min read