Skip to posts
  • Publications
  • Code Library
  • Events
  • Presentations
  • Who Am I?
  • Copyright

Wayne Sheffield

My blog about SQL Server
  • Home
  • Publications
  • Code Library
  • Events
  • Presentations
  • Who Am I?
  • Copyright
  • Latest Posts
  • Latest Comments


MCM


MVP

(2017-2022)

Top 50 SQL blog 2018

Recent Posts

  • Availability Group issues fixed with Alerts
  • Using Google Chrome with SSRS
  • Speakers wanted for the Richmond (VA) SQL Server Users Group – 2020
  • T-SQL Tuesday #120 – Recap
  • T-SQL Tuesday #120 – What were you thinking? – Invitation

Top Posts

  • Using a gMSA with SQL Server
  • Service Packs and Updates - Tables and Download links
  • Working with tabs and spaces in SSMS (Day 34)
  • Checking for temporary table existence
  • Windows Virtual Accounts and SQL Server
  • Availability Group issues fixed with Alerts
  • A month of SSMS tips and tricks
  • Understanding Rebinds and Rewinds
  • Primary Replica Jobs
  • Cannot start SSAS after install in tabular mode

Archives

Categories

Tags

2020 absolute values (ABS()) Advanced Certifications analytic functions assign sequential number automation Availability Group Back To Basics case-sensitive CLR String Security clustered index common table expression Data Movement deadlock analysis Denali Double-Hop efficiency extracting data from strings Failover Functions Google Chrome import file index analysis myth order by Performance physical tally table Quirky Update Scalar UDF Inlining split string splitting strings SQL SQL 2019 SQL Server SSMS SSMS Tips SSRS String Splitter T-SQL Tuesday tally table Trusted Assembly TSQL Tuesday virtual tally table Why do you do what you do? wrapup

Blogroll

  • Rob Farley
  • Thomas LaRock
  • Jason Brimhall
  • Louis Davidson
  • Paul White
  • Brent Ozar
  • Noel McKinney
  • Jen McCown
  • Dave Ballantyne
  • Phil Factor
  • Jack Corbett
  • Benjamin Nevarez
  • Tim Ford
  • Gianluca Sartori
  • Kendra Little

Opt-out preferences

This page was last changed on 2025-04-15, last checked on 2025-04-15 and applies to citizens and legal permanent residents of the United States.

1. Introduction

Our website, //blog.waynesheffield.com/wayne (hereinafter: “the website”) uses cookies and other related technologies (for convenience all technologies are referred to as “cookies”). Cookies are also placed by third parties we have engaged. In the document below we inform you about the use of cookies on our website.

2. Cookies

When you visit our website it can be necessary to store and/or read certain data from your device by using technologies such as cookies.

2.1 Technical or functional cookies

Some cookies ensure that certain parts of the website work properly and that your user preferences remain known. By placing functional cookies, we make it easier for you to visit our website. This way, you do not need to repeatedly enter the same information when visiting our website and, for example, the items remain in your shopping cart until you have paid. We may place these cookies without your consent.

2.2 Statistics cookies

We use statistics cookies to optimize the website experience for our users. With these statistics cookies we get insights in the usage of our website.

2.3 Marketing/Tracking cookies

Marketing/Tracking cookies are cookies or any other form of local storage, used to create user profiles to display advertising or to track the user on this website or across several websites for similar marketing purposes.

3. Placed cookies

Most of these technologies have a function, a purpose, and an expiration period.

  1. A function is a particular task a technology has. So a function can be to “store certain data.”
  2. Purpose is “the Why” behind the function. Maybe the data is stored because it is needed for statistics.
  3. The expiration period shows the length of the period the used technology can “store or read certain data.”

Miscellaneous

Purpose pending investigation

Usage

Sharing data

Sharing of data is pending investigation

Purpose pending investigation

Name
69000_visit
Expiration
Function
Name
_ir
Expiration
Function
Name
cmplz_consented_services
Expiration
365 days
Function
Name
cmplz_policy_id
Expiration
365 days
Function
Name
cmplz_marketing
Expiration
365 days
Function
Name
cmplz_statistics
Expiration
365 days
Function
Name
cmplz_preferences
Expiration
365 days
Function
Name
cmplz_functional
Expiration
365 days
Function
Name
cmplz_banner-status
Expiration
365 days
Function

4. Browser and Device based Consent

When you visit our website for the first time, we will show you a pop-up with an explanation about cookies. You do have the right to opt-out and to object against the further use of non-functional cookies.

4.1 Manage your opt-out preferences

You have loaded the Cookie Policy without javascript support. On AMP, you can use the manage consent button on the bottom of the page.

5. Enabling/disabling and deleting cookies

You can use your internet browser to automatically or manually delete cookies. You can also specify that certain cookies may not be placed. Another option is to change the settings of your internet browser so that you receive a message each time a cookie is placed. For more information about these options, please refer to the instructions in the Help section of your browser.

Please note that our website may not work properly if all cookies are disabled. If you do delete the cookies in your browser, they will be placed again after your consent when you visit our website again.

6. Your rights with respect to personal data

You have the following rights with respect to your personal data:

  • you may submit a request for access to the data we process about you;
  • you may object to the processing;
  • you may request an overview, in a commonly used format, of the data we process about you;
  • you may request correction or deletion of the data if it is incorrect or not or no longer relevant, or to ask to restrict the processing of the data.

To exercise these rights, please contact us. Please refer to the contact details at the bottom of this Cookie Policy. If you have a complaint about how we handle your data, we would like to hear from you.

For more information about your rights with respect to personal data, please refer to our Privacy Statement

7. Contact details

For questions and/or comments about our Cookie Policy and this statement, please contact us by using the following contact details:

Wayne Sheffield
VA
United States
Website: //blog.waynesheffield.com/wayne
Email: wayne@ex.comwaynesheffield.com

This Cookie Policy was synchronized with cookiedatabase.org on 2024-01-08.

Share this:

  • Click to share on X (Opens in new window) X
  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to email a link to a friend (Opens in new window) Email
  • Click to print (Opens in new window) Print
  • More
  • Click to share on Facebook (Opens in new window) Facebook
  • Click to share on Pinterest (Opens in new window) Pinterest
  • Click to share on Reddit (Opens in new window) Reddit

Like this:

Like Loading...
Powered by WordPress Web Design by SRS Solutions © 2025 Wayne Sheffield Design by SRS Solutions
%d