Mid-Week Update
Just a short mid-week update, David Postlethwaite has been selected to speak at SQL Saturday Vienna which is being held...
2015-01-15
601 reads
What to Expect When Transitioning from DBA to Consultant
Last week, Boris Hristov (b|t), the organizer of #SQLHangout, invited William Durkin (b|t) and me to a SQL Hangout about transitioning...
2015-01-15
570 reads
T-SQL to Display Weekends Between two Dates
Different ways to find the weekend between two given dates. The SQL requires @begindate and @endate paramteters to be entered...
2015-01-14
1,048 reads
Part2 Adding a New CheckBox – Create your own SQL tools with PowerShell and Windows forms
Steve:
This is James’ second post on creating SQL tools with PowerShell and Windows forms. James is a DBA responsible for...
2015-01-19 (first published: 2015-01-14)
6,787 reads
Power BI Designer and Power BI Dashboard
Long has the question been asked “Which Microsoft tool do I use for dashboards?”. SSRS, Excel, PowerView, Report Builder and PerformancePoint...
2015-01-14
2,282 reads
VMware Online Event – February 2nd
VMware has recently announced an online event for February 2nd that you don’t want to miss! Whatever it is, it’s going...
2015-01-14
576 reads
Execute the Current Statement–SQL Prompt
This is a great little feature in SQL Prompt that I wrote about at SQLServerCentral. It’s Current statement Execution, which...
2015-01-14
1,281 reads
Common Table Expressions Are Not Tables
There’s power in naming things. Supposedly some types of magic are even based on knowing the correct names for things....
2015-01-20 (first published: 2015-01-14)
8,484 reads
Excel 2013 Conditional Formatting for Columns
If you have two columns in an Excel sheet, and you want to conditionally format fields in the second column...
2015-01-14
776 reads
Award from MSSQLTIPS.com
Today, I am excited and humbled to learn that I am awarded “Rookie of the Year – 2014” by MSSQLTips.com.
I have...
2015-01-14
321 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
BCA KCU MENARA BIDAKARA Telp:0821-8200-203
Telp/WA 62 821-8200-203 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...
BCA KCU KEBAYORAN BARU Telp:0821-8200-233
Telp/WA 62 821-8200-233 Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru,...
BCA KCU PONDOK INDAH Telp:0821-8200-174
Telp/WA 62 821-8200-174 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers