Power BI designer is based upon the Power Query formula language informally known as "M". Unfortunately, the advanced editor inside the Power BI designer does not support syntax highlighting, meaning it can be easy to make mistakes. Matt Mason shows how you can extend the Notepad++ editor to support this feature.
Today Steve Jones looks at the problems we have with hiring staff and the troubles we go through. Perhaps we can do better with an investment in our people.
In this follow-up to Beyond the LIKE Operator: Advanced Pattern Matching with MySQL, Rob Gravelle shows how to use the REGEXP operator to match alphanumeric characters, explores the role of meta-characters, and compares standard regular expression syntax to that of MySQL.
PowerShell is an ideal tool for doing health-checks of a collection of SQL Server instances, and there are several examples around, but few acknowledge the fact that individual DBAs have their own priorities for tests, and need something easily changed to suit circumstances. Omid Afzalalghom's Healthcheck allows tests to be SQL or PowerShell and requires only adding, altering or deleting files in directories.
This article shows the procedure to Add new disks to SQL Server failover cluster in windows 2008/2008R2. This article also covers how to add dependencies to a SQL Server cluster resource.
Phil Factor is gratified to see just how much many developers and DBAs give back to their technical communities as well as society in general.
One NoSQL database is not necessarily like another. Steve Jones notes that some of the complaints out there will likely be easily overcome.
Glenn Berry introduces the exciting new feature in Windows Server 2016 called Storage Spaces Direct (S2D), which enables organizations to use multiple, clustered commodity file server nodes to build highly available, scalable storage systems with local storage, using SATA, SAS, or PCIe NVMe devices.
Do you know if your SQL Server is really running at its best? To...
You can find the slides of my session on the €100 DWH in Azure...
By Steve Jones
This value is something that I still hear today: our best work is done...
Comments posted to this topic are about the item Single User SQL Server on...
Comments posted to this topic are about the item All the Costs of Downtime
Comments posted to this topic are about the item How Well Does the MSSQL...
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers