{"id":110601,"date":"2026-05-14T08:26:42","date_gmt":"2026-05-14T08:26:42","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?post_type=collection&p=110601"},"modified":"2026-05-14T08:26:44","modified_gmt":"2026-05-14T08:26:44","slug":"the-complete-too-shy-to-ask-series","status":"publish","type":"collection","link":"https:\/\/www.red-gate.com\/simple-talk\/collections\/the-complete-too-shy-to-ask-series\/","title":{"rendered":"The complete ‘Too Shy to Ask’ series"},"content":{"rendered":"\n

What are the database and technology questions you’re simply too shy to ask?<\/em><\/strong><\/p>\n\n\n\n

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

\n
\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tData Privacy and Protection<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Rebecca Edwards<\/span>\n <\/a>\n\n \n in<\/span>\n \n Data Privacy and Protection <\/a>\n <\/span>\n<\/div>\n\n
\n

\n Questions About HIPAA That You Were Too Shy to Ask <\/h1>\n

\n As a data professional or developer, you will likely have questions about how HIPAA impacts you and your day to… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tDatabase Administration<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Kathi Kellenberger<\/span>\n <\/a>\n\n \n in<\/span>\n \n Database Administration <\/a>\n <\/span>\n<\/div>\n\n
\n

\n Questions About Kerberos and SQL Server That You Were Too Shy to Ask <\/h1>\n

\n Kerberos authentication is a topic that many database administrators avoid. It\u2019s really not that difficult to understand, but it\u2019s also… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tOpinion Pieces<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n William Brewer<\/span>\n <\/a>\n\n \n in<\/span>\n \n Opinion Pieces <\/a>\n <\/span>\n<\/div>\n\n
\n

\n Questions About Data Breaches that You Were Too Shy to Ask <\/h1>\n

\n News reports about data breaches are common occurrences. Even the companies that exist to keep our data safe are not… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tOpinion Pieces<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n William Brewer<\/span>\n <\/a>\n\n \n in<\/span>\n \n Opinion Pieces <\/a>\n <\/span>\n<\/div>\n\n
\n

\n Questions about Data Governance that You Were Too Shy to Ask <\/h1>\n

\n A company\u2019s data is one of its most valuable and important resources. Managing and protecting that data are big responsibilities,… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tOpinion Pieces<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n William Brewer<\/span>\n <\/a>\n\n \n in<\/span>\n \n Opinion Pieces <\/a>\n <\/span>\n<\/div>\n\n
\n

\n Questions about Data Masking That You Were Too Shy to Ask <\/h1>\n

\n The General Data Protection Regulation (GDPR) will be in effect in May of 2018. Data masking is one technique that… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tOpinion Pieces<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n William Brewer<\/span>\n <\/a>\n\n \n in<\/span>\n \n Opinion Pieces <\/a>\n <\/span>\n<\/div>\n\n
\n

\n Questions About the GDPR That You Were Too Shy to Ask <\/h1>\n

\n The General Data Protection Regulation (GDPR) will affect organisations in countries around the world, not just those in Europe. The… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Laerte Junior<\/span>\n <\/a>\n\n \n <\/span>\n<\/div>\n\n
\n

\n Questions About Amazon Data Migration Service (AWS DMS) That You Were Too Shy to Ask <\/h1>\n

\n Can you imagine it? You are in a group of smart database people, and they are debating the finer points… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Laerte Junior<\/span>\n <\/a>\n\n \n <\/span>\n<\/div>\n\n
\n

\n Questions About RDS SQL Server That You Were Too Shy to Ask <\/h1>\n

\n There are a number of different ways that you can host SQL Server. RDS SQL Server, for example, uses SQL… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tT-SQL Programming<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Robert Sheldon<\/span>\n <\/a>\n\n \n in<\/span>\n \n T-SQL Programming <\/a>\n <\/span>\n<\/div>\n\n
\n

\n Questions About SQL Server Collations You Were Too Shy to Ask <\/h1>\n

\n Of course we all like our colleagues to think that we know everything there is to know about SQL Server… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tDatabase DevOps<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n William Brewer<\/span>\n <\/a>\n\n \n in<\/span>\n \n Database DevOps <\/a>\n <\/span>\n<\/div>\n\n
\n

\n Questions About the Use of PowerShell That you were Too Shy to Ask <\/h1>\n

\n Let’s forget the actual PowerShell code for a moment: Why is PowerShell important? Why should I use it? Where did… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tDatabase DevOps<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n William Brewer<\/span>\n <\/a>\n\n \n in<\/span>\n \n Database DevOps <\/a>\n <\/span>\n<\/div>\n\n
\n

\n Questions About SQL Server Security and Access Control You Were Too Shy to Ask <\/h1>\n

\n For many developers, database security and Access control is just something that gets in the way of development work. However,… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Laerte Junior<\/span>\n <\/a>\n\n \n <\/span>\n<\/div>\n\n
\n

\n Questions About PowerShell Basics That You Were Too Shy To Ask <\/h1>\n

\n Developers who are already familiar with application languages will be baffled by different aspects of PowerShell to the beginner to… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n William Brewer<\/span>\n <\/a>\n\n \n <\/span>\n<\/div>\n\n
\n

\n Questions About CUBE, ROLLUP and GROUPING SETs That You Were Too Shy to Ask <\/h1>\n

\n There are few parts of SQL Syntax as familiar as the GROUP BY clause of the SELECT statement. On the… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Adam Bertram<\/span>\n <\/a>\n\n \n <\/span>\n<\/div>\n\n
\n

\n Questions About Devops that IT Pros are Too Shy to Ask <\/h1>\n

\n DevOps isn’t a particular technology, nor a job role. It is more of a software development method, initiating originally from… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Tony Davis<\/span>\n <\/a>\n\n \n <\/span>\n<\/div>\n\n
\n

\n Questions About SQL Server Transaction Log You Were Too Shy To Ask <\/h1>\n

\n You can give a deep-dive presentation about SQL Server’s transaction log, and round it off by inviting questions. Your audience… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Robert Sheldon<\/span>\n <\/a>\n\n \n <\/span>\n<\/div>\n\n
\n

\n Questions About T-SQL Control-of-Flow Language You Were Too Shy to Ask <\/h1>\n

\n Surely, we all know how T-SQL Control-of-flow language works? In fact it is surprisingly easy to get caught out. What,… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Robert Sheldon<\/span>\n <\/a>\n\n \n <\/span>\n<\/div>\n\n
\n

\n SQL Server PIVOT: 12 Questions Answered (Multi-Column, Dynamic, UNPIVOT) <\/h1>\n

\n Twelve answered questions about the SQL Server PIVOT operator: how PIVOT rotates data, controlling grouping, column aliases, multi-column pivots, dynamic… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Robert Sheldon<\/span>\n <\/a>\n\n \n <\/span>\n<\/div>\n\n
\n

\n Questions About T-SQL Transaction Isolation Levels You Were Too Shy to Ask <\/h1>\n

\n Every time you access a relational database to make a query, you have an important decision to make: What is… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Robert Sheldon<\/span>\n <\/a>\n\n \n <\/span>\n<\/div>\n\n
\n

\n Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask <\/h1>\n

\n It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Robert Sheldon<\/span>\n <\/a>\n\n \n <\/span>\n<\/div>\n\n
\n

\n Questions about SQL Server Primary and Foreign Keys You Were Too Shy to Ask <\/h1>\n

\n It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without… <\/p>\n <\/div>\n

\n