Redgate Reviews 2018, Predicts 2019
Our boss came to us and said, “We need one more webinar to round out the year.” Well, we’re just...
2018-12-17
180 reads
Savings changes is not permitted. The changes you have made require the following tables to be dropped and re-created.
Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error...
2018-12-17
1,035 reads
Azure SQL Database DTU Versus vCore
I wrote a guest article for an IT consultancy on Azure SQL Database, more specifically DTUs and vCore options. At...
2018-12-17
879 reads
MongoDB – Basic
MongoDB is a great Database NOSQL and easy to use and learn. if you know java scripting and database concept...
2018-12-17
828 reads
SQL Server services will not start automatically after server reboots
This blog post is about a situation where after windows patching the SQL Server service and SQL Server Agent services...
2018-12-17
325 reads
Processing Multiple Files in SSIS with the Foreach Loop
Yesterday I wrote about the little-known but still useful multiple flat file connection manager. In this post, I will briefly show a more commonly used alternative approach for processing...
2018-12-17
29 reads
Processing Multiple Files in SSIS with the Foreach Loop
Yesterday I wrote about the little-known but still useful multiple flat file connection manager. In this post, I will briefly...
2018-12-17
197 reads
PowerShell Multithreading with PoshRSJob
Intro PowerShell has had a native method for spawning multiple “threads” ever since I can remember, in the form of the *-Job functions. They work OK, but there are...
2018-12-17
42 reads
Last week reading (2018-12-16)
Hello data geeks. Last week we had many news about Cosmos DB, and this time the top topics are Power...
2018-12-16
182 reads
Global AI Bootcamp – Developing AI, responsibly
Global AI Bootcamp, Brisbane 2018 Yesterday, I attended the Global AI Bootcamp Brisbane (at the Precinct, Valley) along with nearly 100 other technology enthusiasts. The event was well organized by...
2018-12-16
17 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers