I was given a little reward the other day. My son came home telling me that the manufacturing company he works for wants to build some custom test equipment using Arduino-style controller chips. I've been experimenting, pretty darned lightly so far, with these over the last year. He starts asking me about which controllers I […]
If you found out you were being laid off, would you be ready? Steve thinks you should be lightly planning for this to happen.
This article looks at manipulating data using Python to unpivot data received in a cross tab format.
This article demonstrates a cross-RDBMS way of searching through a set of SQL migration files, in the right order, to get a narrative summary of what changes were made, or will be made, to one or more of the tables or routines within each migration file. Getting these summary reports, even from a set of SQL migrations, isn't difficult, but having a few examples makes it a lot quicker to get started.
Microsoft Power BI is an interactive data visualization tool primarily designed with business intelligence in mind. Apart from being a visualization tool, it also has some built-in security features that we will discuss in this article.
Learn how to implement parameters in Power BI.
Microsoft is recommending more security for SQL Servers, including dev and test instances. Do you agree this is a good idea? Would you implement this?
Your first speakers in the lineup for PASS Data Community Summit 2023 have been announced! Check out the full details for this year's Pre-Cons and Learning Pathways, and find out why some of our speakers are particularly excited for what’s in store this year.
This article will show you how to page through a set of results using the OFFSET and FETCH options of the ORDER BY clause.
A post on distributed systems and how schema changes are handled caught Steve's eye. See if you agree with how he thinks this should work.
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers