Good IT data governance is about crime-prevention as well as crime-detection. Legal action runs war a close second as being one of the more futile and debilitating of human activities, so prevention is always better.
Would you be more productive outside of an office? Would you take a pay cut to work outside of an office? Steve Jones notes that a number of IT professionals said they would.
Phil Factor's newest SQL expression calculates when all the feasts and saints days are, giving you plenty of potential causes for celebration.
This tool is a helper for your daily work to copy easily databases between Servers/instances and do all the necessary stuff for you.
Today we have a guest editorial from Erin Stellato that reminds us that we have had support from many, and it's important to thank them from time to time.
SQL Server's Query Store, introduced in SQL Server 2016, helps to troubleshoot query performance by capturing a range of information about query usage, CPU, memory consumption, I/O and execution time, and retaining every Execution Plan for analysis. Much of this information is available through queries. It looks set to be the most significant enhancement of SQL Server 2016 - Enrico van de Laar explores.
The DevOps moniker seems to bring together good practices that some companies have followed for years. However lots don't, and today Steve Jones tries to get inspire a few of you to give it a try.
Power BI designer is based upon the Power Query formula language informally known as "M". Unfortunately, the advanced editor inside the Power BI designer does not support syntax highlighting, meaning it can be easy to make mistakes. Matt Mason shows how you can extend the Notepad++ editor to support this feature.
Today Steve Jones looks at the problems we have with hiring staff and the troubles we go through. Perhaps we can do better with an investment in our people.
In this follow-up to Beyond the LIKE Operator: Advanced Pattern Matching with MySQL, Rob Gravelle shows how to use the REGEXP operator to match alphanumeric characters, explores the role of meta-characters, and compares standard regular expression syntax to that of MySQL.
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Comments posted to this topic are about the item Semantic Search in SQL Server...
Comments posted to this topic are about the item Encoding URLs
Comments posted to this topic are about the item An SSIS Upgrade
I have this data in a table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers