Preparing for Exam 70-767: Implementing a Data Warehouse
- Posted in:
- Career
- Certification
- Microsoft
A recap of how I prepared for and passed Exam 70-767: Implementing a Data Warehouse using SQL.
[...Read More]
What's Your Learning Style?
- Posted in:
- Career
- Certification
- Microsoft
Combining two popular learning styles hits the sweet spot.
[...Read More]
tempdb: Are We There Yet?
- Posted in:
- Database Administration
- SQL Agent
- SQL Server
SQL Server can tell you when [tempdb] is out of space. And you don't even have to ask!
[...Read More]
SQL Server Features Discovery Report
- Posted in:
- Database Administration
- Development
- PowerShell
- Windows
Some scripting options for running the SQL Server features discovery report.
[...Read More]New For SQL Server 2017: T-SQL Function CONCAT_WS
- Posted in:
- Development
- SQL Server 2017
- T-SQL
Concatenate With Separator-a new T-SQL function that "addresses" a real world problem.
[...Read More]
New For SQL Server 2017: T-SQL Function TRIM
- Posted in:
- Development
- SQL Server 2017
- T-SQL
SQL Server 2017 gives us the new T-SQL function TRIM(), which has an added surprise.
[...Read More]
STRING_AGG Return Types
- Posted in:
- Development
- SQL Server 2017
- T-SQL
After stubbing my toe on return data types, I find the new SQL Server 2017 function STRING_AGG() is pretty cool.
[...Read More]
Formatting Dates with CONVERT
- Posted in:
- Development
- SQL Server
- SSMS
- T-SQL
Can you remember all the date and time styles supported by CONVERT? Me neither!
[...Read More]
Installing SSRS 2017
- Posted in:
- Database Administration
- SQL Server 2017
- SSRS
SQL Server Reporting Services 2017 now has a separate installation. There have been changes...
[...Read More]
T-SQL Tuesday #98: Technical Challenges
- Posted in:
- Database Administration
- Security
Dave shares a technical challenge for T-SQL Tuesday #98.
[...Read More]