The State of Data Growth
Data continues to grow at incredible rates. That's good for those of us that make a living with data.
2021-09-11
246 reads
Editorials
New Old Architectures
The idea of event driven, rather than tightly coupled architectures is one that Steve thinks data professionals should learn more about.
2021-09-10
285 reads
Patterns and Potential Problems
We use patterns in software development to make things easier. This is especially true in database changes. Steve reminds you that all solutions might have a downside of which you need to understand.
2021-09-08
175 reads
Live Your Life
On this holiday in the US, Steve reminds us that living a life we want and enjoy isn't something we should delay for the future.
2021-09-06
162 reads
The Leaves Are Changing, But Why?
I've recently moved house from Massachusetts to Oklahoma. Long story. Anyway, sitting in my new office looking out at the trees, some of the leaves are starting to change. Ah, Fall. Lovely Autumn colors... WAIT! Actually, something else is going on. Only a few trees are changing color. Word is, we've been a little dry […]
2021-09-04
175 reads
Enhancing Client Experiences with Data and Analysis
Data can enhance the experience our client's have with software.
2021-09-03
107 reads
Where We Need Better AI Disclosure and Responsibility
The way that AI is used in the world can make it better, but not always. In either case, we ought to have some accountability for the models.
2021-09-01
205 reads
Eyes Wide Open
Trying to architect a new database system so that you don't outgrow it is a challenge, but the more you think about early, the better off you will be.
2021-08-30
174 reads
What to do with more free time
Many data professionals have begun working remotely over the past year and a half which translates to less time spent commuting. In my own case, I’ve been a remote worker for almost ten years, but before that I spent two hours on the road each day. This got me wondering what folks have done with […]
2021-08-28
256 reads
Are You a Tech Company?
Is your company a tech company? Steve Jones looks at the world from the perspective of software development and how that impacts business.
2021-08-27 (first published: 2016-09-20)
136 reads
Blogs
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
MEMORYBROKER_FOR_RESERVE experience
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
Moving Database Files
I just learned that my database was created on my C:\ drive in the...
Migrate MSSQL to MYSQL - Different Servers
I am needing to migrate a MSSQL db to MySQL, on a different server...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers