Securing Your Instances
This week Steve Jones looks at moving the port numbers of your instances for a bit of security.
2022-11-25 (first published: 2017-01-13)
205 reads
Editorials
AI Medical Record Scanning
Artificial Intelligence can help humans, both in diagnosis, but also in teaching medical professionals.
2022-11-23
143 reads
The Challenge of New Platforms
As our organizations grow, they may add new data stores. That might not be the best decision for staff as the amount of knowledge they need grows. Steve notes that you might seek to limit the number of technologies you support.
2022-11-21
211 reads
Challenging Yourself
Steve is challenging himself to do better, which means he might not hit his goals.
2022-11-18
107 reads
Self-Service Databases
When I first started work as a software developer, I knew that getting an environment set up where I could compile a project might take a few hours or a few days. The complexities of how people built software projects, the dependencies, and more were handled in a very immature manner. These days I can […]
2022-11-16
211 reads
What's the Edge Case?
Building software means not only considering the data people expect, but also edge cases. Steve asks if you know what those edge cases are?
2022-11-14
290 reads
Practical IOT
The use of IoT and lots of data is allowing governments to better serve their citizens.
2022-11-12
120 reads
Losing Skills Because of Automation
When I was younger, it seemed that everyone I worked with in technology knew how to build a computer. Most knew how to work with a BIOS, were comfortable with command lines, and could assemble complex compiler directives into a Make file. Over time, it seems many people, especially Windows and MacOS users, became focused […]
2022-11-11
210 reads
Psychological Safety
Building psychological safety inside of a company is hard, but it is important to build trust and develop a team.
2022-11-09
84 reads
DevOps is Culture
A big part of adopting DevOps and becoming better at building software is establishing culture.
2022-11-07
204 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
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