For Hire: Data Analytics/Business Intelligence Expert
Data Analytics/Business Intelligence Expert Strengths: Passion, great with people, loves to learn and teach Weaknesses: Chocolate, fast cars, death Inquire...
2017-08-07
482 reads
TheSqlPro.com - Ayman El-Ghazali
SQL Server 2016: A Comprehensive Introduction – Arabic
It has been over a year since I have blogged, I know… that’s a long time! I have not retired,...
2017-04-26
338 reads
PolyBase: I now Pronounce you SQL and Hadoop
Are you interested in Hadoop? With SQL Server 2016 just around the corner, a powerful new feature is being included called...
2016-04-27
1,016 reads
SQL Server 2016: What’s the best new feature?
With SQL 2016 around the corner, and my blog without a post this year, I thought I would write about...
2016-04-28 (first published: 2016-04-19)
4,327 reads
Get valuable Virtual Log File (VLF) information for all your databases log files
I had this problem where I needed to gather Transaction Log information on multiple databases and check for valuable statistics on...
2015-11-09 (first published: 2015-11-02)
2,021 reads
SQL 2016 Row-Level Security Demo: Users with various clearance levels
SQL 2016 is right around the corner and one of the new security enhancements promised is Row-Level security for tables....
2015-10-01
1,276 reads
Another Career Podcast – Working at Microsoft
I have to admit, I had a lot of fun at SQL Saturday in Philly this last June; I mean...
2015-08-07
483 reads
Podcast about my career and the SQL Server Community with Chris Bell
During my time at SQL Saturday in Philadelphia (Early June), Chris Bell invited me to be a guest on his...
2015-07-09
652 reads
Working at Microsoft – A Year in Reflection
Last year after starting my new job with Microsoft as a Senior Consultant I wrote an article about my interviewing...
2015-06-24
670 reads
SQL Server 2014 BI ???? ??????? ????? ??
??????? ??????? ?? ??????! ?????? ????? ? ???? ???? ? ?????? ???? ??? ???? ??????? ????? ?? SQL Server 2014...
2015-03-29
991 reads
Blogs
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Playing with the Data API Builder
By Steve Jones
I published an article today on the Data API Builder, which is a way...
A New Word: Dolonia
By Steve Jones
dolonia – n. a state of unease prompted by people who seem to like...
Forums
Understanding allowed topics for testing
Hi, I am a first time writer looking to author some content here. I...
Do As I Say, Not As I Do
Comments posted to this topic are about the item Do As I Say, Not...
Filter a SQL Server Audit with a predicate
Hi Gents, Silly question, but it's been a long time since I've done this....
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 GOHow big is the new log file? See possible answers