Blog

Page 155 of my articles, tutorials, and thoughts

Latest Articles

Cover Image for How do I generate a random number for each row in a T-SQL select?

How do I generate a random number for each row in a T-SQL select?

Published on September 2, 2023

# How to Generate a Random Number for Each Row in T-SQL Select? 🎲 Are you struggling to generate a unique random number for each row in your T-SQL select statement? Look no further! In this blog post, we'll dive into this common issue and provide you wit

Cover Image for How to determine the current language of a wordpress page when using polylang?

How to determine the current language of a wordpress page when using polylang?

Published on September 2, 2023

# πŸ” How to Determine the Current Language of a WordPress Page when Using Polylang? 🌐 Are you using the Polylang plugin on your WordPress website to create a multilingual experience for your visitors? Awesome! But wait, how can you determine the current

Cover Image for How to create a yes/no boolean field in SQL server?
boolean

How to create a yes/no boolean field in SQL server?

Published on September 2, 2023

# How to Create a Yes/No Boolean Field in SQL Server? Are you struggling with converting a database from Access to SQL Server and wondering how to create a Yes/No or Boolean field? Look no further! In this guide, we will address this common issue and prov

Cover Image for Ignore javascript syntax errors in a page and continue executing the script
htmljavascriptjqueryplugins

Ignore javascript syntax errors in a page and continue executing the script

Published on September 2, 2023

# How to Ignore JavaScript Syntax Errors and Keep Your Plugin Running Smoothly πŸ˜ŽπŸ’»βœ¨ Are you a WordPress plugin developer who has faced the frustrating issue of your plugin's JavaScript failing to execute due to errors from other plugins? 😫 Don't worry,

Cover Image for Sleep Command in T-SQL?
asynchronoussleep

Sleep Command in T-SQL?

Published on September 2, 2023

## Sleep Command in T-SQL: Mastering the Art of Slowing Things Down πŸ˜΄πŸ’€ Ever wished you could just hit the pause button ⏸️ in your T-SQL script and make it sleep for a while? Maybe you're writing a web service and want to mimic the behavior of a slow ext

Cover Image for Why is WordPress placing "text/rocketscript" instead of "text/javascript" when using wp_register_script()?

Why is WordPress placing "text/rocketscript" instead of "text/javascript" when using wp_register_script()?

Published on September 2, 2023

# Why is WordPress placing "text/rocketscript" instead of "text/javascript" when using wp_register_script()? If you've ever used the `wp_register_script()` function in WordPress to enqueue a script, you may have encountered a strange issue where WordPress

Cover Image for Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes)

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes)

Published on September 2, 2023

# How to Fix the "Fatal error: Allowed memory size exhausted" Error in WordPress πŸ‘‹ Hey there, fellow WordPress enthusiasts! πŸ˜„ So, you're trying to open a dashboard page on your WordPress site but instead, you're greeted with a scary error message that

Cover Image for sql server invalid object name - but tables are listed in SSMS tables list

sql server invalid object name - but tables are listed in SSMS tables list

Published on September 2, 2023

# SQL Server Invalid Object Name: Tables Listed in SSMS but Not Recognized by Intellisense Are you facing an issue where your SQL Server Management Studio (SSMS) is not recognizing some of the tables you have created, even though they are listed in the ta

Cover Image for SQL Server Profiler - How to filter trace to only display events from one database?

SQL Server Profiler - How to filter trace to only display events from one database?

Published on September 2, 2023

πŸ” **SQL Server Profiler: Filtering Trace for a Specific Database** If you're working with SQL Server Profiler and find yourself overwhelmed by the sheer volume of events from different databases, don't worry! You're not alone in this struggle. πŸ€” One co

Cover Image for What are the best practices for using a GUID as a primary key, specifically regarding performance?
guid

What are the best practices for using a GUID as a primary key, specifically regarding performance?

Published on September 2, 2023

# The Best Practices for Using GUIDs as Primary Keys: Performance Edition πŸš€ So, you've been using GUIDs as primary keys in your application, but you've heard rumors about potential performance issues. You're not alone! Many developers have faced similar