SQLServerCentral Newsletter for September 27, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central](
Featured Contents - [Diving Deeper into the Import Extension in Azure Data Studio](
- [The PASS Data Community Summit Session Schedule is LIVE!](
- [Bad Data and Dirty Databases](
- [From the SQL Server Central Blogs - Connect to Power BI as a Guest User in another Tenant](
- [From the SQL Server Central Blogs - What I learned volunteering at a children's summer camp](
- [The Unicorn Project]( Question of the Day - [Enable a Disabled Index](
The Voice of the DBA
 Dead to Me I saw a note from someone recently that reminded me of [Policy-Based Management](. This was (is?) a technology in SQL Server that I thought might have great potential. I even had a few presentations on the subject, but sadly I've rarely seen anyone implement it. I'm sure some do, but I think for me, this is dead technology. There have been other tech items from which I've been turned off or abandoned over the years. It seems in SQL Server, we have some tech that even Microsoft has abandoned and doesn't put any development resources into improving. This week, I'm asking if you have technology that's dead to you. It could be in the SQL Server or Microsoft Data Platform, or it could be elsewhere. Let us know in the discussion below. I have often moved on from some technology to something newer or better, but that's not because the old software was dead to me, but rather because I found something better. However, I have abandoned some things. Database Mirroring is something I see as dead, as does Microsoft. I think for me, any source control system other than Git is dead to me, though maybe that's more because Git has proven to be better (and ubiquitous). I'd say that I find most multi-platform messaging clients dead to me, mostly because they can't keep up or implement good interfaces that work across many places. At least not in a way that makes sense for me. I'd say these days, digital cameras (and video cameras) are dead to me as a casual snapper who can live with a phone. I'm sure there are other dead technologies that you're just annoyed with or think don't (or can't) meet your needs. There are likely many more which didn't keep up with you over time, which you wouldn't have abandoned if they had just improved a bit. Let us know today what you think. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](
Â
 Featured Contents [SQLServerCentral Article]( [Diving Deeper into the Import Extension in Azure Data Studio]( Steve Jones - SSC Editor from SQLServerCentral Azure Data Studio (ADS) is a lightweight IDE built... [Technical Article]( [The PASS Data Community Summit Session Schedule is LIVE!]( Additional Articles from PASS Join over 170 global data experts offering more than 150 sessions designed for all skill levels. Explore the schedule to plan your days on-site, secure your ticket, and book your travel before prices increase. [External Article]( [Bad Data and Dirty Databases]( Additional Articles from SimpleTalk Many years ago, my wife and I wrote an article for Datamation, a major trade publication at the time, under the title, âDonât Warehouse Dirty Data!â Itâs been referenced quite a few times over the decades but is nowhere to be found using Google these days. The point is, if you have written a report using data, you have no doubt felt the pain of dirty data and it is nothing new. [Blog Post]( From the SQL Server Central Blogs - [Connect to Power BI as a Guest User in another Tenant]( Koen Verbeeck from Koen Verbeeck Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added as a guest user in another tenant. This happens quite a lot when youâre a... From the SQL Server Central Blogs - [What I learned volunteering at a children's summer camp]( Rayis Imayev from Data Adventures  "Stories are where memories go when they are forgotten" - Doctor Who.(2024-Sep-13) As September quickly moves forward, with schools starting and kids returning to their routines, the memories of the... [The Unicorn Project]( Site Owners from SQLServerCentral In The Unicorn Project, we follow Maxine, a senior lead developer and architect, as she is exiled to the Phoenix Project, to the horror of her friends and colleagues, as punishment for contributing to a payroll outage. She tries to survive in what feels like a heartless and uncaring bureaucracy and to work within a system where no one can get anything done without endless committees, paperwork, and approvals.   Question of the Day Today's question (by Steve Jones - SSC Editor):  Enable a Disabled Index I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) Disable All the Indexes How do I disable all the indexes on the dbo.Logger table? Answer: ALTER INDEX ALL on dbo.Logger DISABLE Explanation: The ALTER INDEX command takes ALL instead of an index name with the table and the disable option. Ref: Disabling Indexes - [ [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2017 - Development
[Error 28054 related to master key root cause and solution required]( - I am getting the following error in SQL Server Error Log randomly on few days. I want to know the root cause for this error so that we can decide on applicable solution for this particular error. Service Broker needs to access the master key in the database. Error code:32. The master key has to [â¦]
[How to attach Database created in higher version to lower version of SQL Server]( - I have attempted to attach a database created in a higher version of SQL Server to a lower version, but I encountered errors. I also tried the backup and restore method, which resulted in errors as well. According to the following link, I explored several options but was unsuccessful: 1. Generate Scripts Wizard in [â¦]
SQL Server 2016 - Administration
[application not connecting to secondary]( -  Hi the application which has the connection string of the listener configured connects to node S01 but when failed over to S02 it does not connect there are no applicable error in the SQL logs and windows logs please let me know  Â
Development - SQL Server 2014
[Query to return all data that has same site, section and date]( - I have a query Select Id, WOCode, Site, Section, CompletionDate from work orders where type = 'BRE'. I want to be able to return list of all WOCode that has same Site,Section and CompletionDate. The date field will be date only with no time
SQL Server 2019 - Administration
[sql monitoring tool]( - Has anybody had any experience with Nagios as a SQLServer monitoring tool. What were the pros and cons you had faced while using it. Please advise.
[Failed restore database]( - Hi All , I have issue restoring small database . SQL version : SQL 2014 In the server , At first I took a backup of database ( bak file ) and compressed it . Then I copied ( standard copy ) to my local laptop from server , after that I copied back to [â¦]
SQL Server 2019 - Development
[max and min dates]( - Hi I am trying to get the first and last days for the following where date_next_compare is less than 28 but having more than that would mean the max date for that range. Sorry if isn't clear. I currently have this:  I want to see two rows like below. I tried doing min and [â¦]
[Pivot Mistake]( - Hi all, I have this query where I make a pivot to extract the data segmented by Hours: select âAmountâ as Amount, [0] ,[1] ,[2] ,[2] ,[3] ,[4] ,[5] ,[6] ,[7] ,[8] ,[9] ,[10] ,[11] ,[12] ,[13] ,[14] ,[15] ,[16] ,[17] ,[18] ,[19] ,[20] ,[21] ,[22] ,[23] from (select sum(efeneg) âAmountâ,left(hormsg,2) âTimeâ,left(hormsg,2) âTimeâ,left(hormsg,2) âTimeâ. from [â¦]
[open query via linked server to db2 is showing terrible performance]( - Hi this post is mostly about cross server concepts vs a query being sent to and run on the target server and then the data simply coming back over the network. but any feedback is appreciated. we have a sql server linked server thru which the db2 erp query (view) shown below is sent to [â¦]
General
[What is Azure Data Studio or GitHub asking me?]( - I have an Azure Data Studio question (or maybe it's a GitHub question, I'm not sure), but I couldn't find a forum here to ask it. So, please excuse my asking it here. I am busy writing a T-SQL script, using Azure Data Studio. I committed my changes locally, then I tried pushing them to [â¦]
[How do data visualization consultants overcome the challenge of integrating?]( - Integrating multiple data sources is challenging due to differences in data formats, structures, and quality. Data visualization consultants must first establish data connections and ensure consistent data formatting. This often involves using ETL (Extract, Transform, Load) processes to clean and combine data. They must also handle data refreshes and ensure that integrated data is up-to-date. [â¦]
SQL Server 2022 - Administration
[SQLExternalMonitoring what is it in sp_who2 result]( - If I run sp_who2, one of item in the list is showing using program SQLExternalMonitoring , what is it? it uses quite a bit cpu and ram. 70 sleeping NT AUTHORITY\SYSTEM SNOCSMASQP01 . master AWAITING COMMAND 170846212 57458731 09/26 10:31:41 SQLExternalMonitoring 70 0 Â Thanks,
[Linked Server to SAP HANA database.]( - Greetings all. It's been a very long time, but I'm back. Does anyone have experience with setting up a linked server to a SAP HANA database? I have hanaclient-2.8.20-windows-x64 installed and a DSN created using the HDBODBC driver that comes with the client install. I am able to use the DSN to connect with generic [â¦]
[SQL job & SSIS package excution]( - Hi SQL experts, We have installed SQL Server with 2022 and using this as SSIS server. SSIS DB is the only one database on this server. We deployed a SSIS package, which is scheduled to run every 1 hr through SQL agent job. The job is failing sometimes & running successfully other times. The job [â¦]
SQL Server 2022 - Development
[SQL Query Optimizer Supporting Parameterized Query and WHERE Clause Optimization]( - I am looking for a SQL query optimization tool that can enhance my query execution times. I have already tried EverSQL and SQL Tuning, but they are not meeting my requirements for the following reasons: 1. Parameterized Queries: Both tools seem to struggle with parameterized queries and do not optimize them correctly. 2. WHERE Clause [â¦]
  [RSS Feed]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -