Kamil

My name is Kamil Nowinski and I'm the founder & owner of SQLPlayer blog.
I'm Microsoft Data Platform MVP, MCSE. Senior Data Engineer, data geek and friend of Redgate. I speak at user groups and conferences across Europe. Love #SQLfamily and Community around Microsoft Data Platform - that's why my podcast is called "Ask SQL Family" where I talk to well-known and valued specialists in the industry (including Microsoft employees).

All authors

Blog Post

Last Week Reading (2021-11-28)

?? Press SynapseML: A simple, multilingual, and massively parallel machine learning library Microsoft just announced the release of SynapseML (previously known as MMLSpark) SSH File Transfer Protocol (SFTP) support...

2021-11-28

4 reads

Blog Post

Last Week Reading (2021-11-28)

? Press SynapseML: A simple, multilingual, and massively parallel machine learning library Microsoft just announced the release of SynapseML (previously known as MMLSpark) SSH File Transfer Protocol (SFTP) support...

2021-11-28

Blog Post

SQL Server 2022 is coming

SQL Server 2022 is still in private preview (Microsoft MVP folks have access to it), but you can now read about the new release before it is released:  SQL...

2021-11-22

177 reads

All authors

Blogs

Free SQL Training: Dive into Databases This December!

By

Want to learn SQL and get some real practice this December? Check out the...

Playing with the Data API Builder

By

I published an article today on the Data API Builder, which is a way...

A New Word: Dolonia

By

dolonia – n. a state of unease prompted by people who seem to like...

Read the latest Blogs

Forums

Understanding allowed topics for testing

By avishwan

Hi, I am a first time writer looking to author some content here. I...

Do As I Say, Not As I Do

By Grant Fritchey

Comments posted to this topic are about the item Do As I Say, Not...

Filter a SQL Server Audit with a predicate

By michal.lisinski

Hi Gents, Silly question, but it's been a long time since I've done this....

Visit the forum

Question of the Day

The New Log File

I have a detached database from SQL Server 2019, called TDE_Primer. This database had a 100MB data file and a 73MB log file. The log file was lost, so I need to run this code: 

USE [master]
GO
CREATE DATABASE [TDE_Primer] ON 
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\TDE_Primer.mdf' )
 FOR ATTACH_REBUILD_LOG
GO
How big is the new log file?

See possible answers