Forum Replies Created

Viewing 15 posts - 1 through 15 (of 5,717 total)

  • Reply To: Anyone Can Click Through Once

    Automation scripts are also good for documentation and certification. For example, if you can codify your month end process into a single script using a high level language like PowerShell,...

  • Reply To: Tough Interview Questions

    When I've done interviews in the past for an intermediate or above level position, I've asked mostly 'why', 'how', 'give an example of', and 'tell me about' type questions.

    • Instead...
  • Reply To: Security in the Aftermath

    A lot of the rioters appeared to have smart phones - which they were using to video record their escapade. The FBI could subpoena location data from Google, Apple, and...

  • Reply To: Security in the Aftermath

    Madame Pelosi's laptop was stolen. Are PCs or devices used by members of Congress have some form of (FTE) full disk encryption enabled? For government issued devices, someone in the...

  • Reply To: Microsoft Fights Back

    My understanding of the SolarWinds hack is that the password to the FTP site used for software releases (SolarWinds123) was inadvertently leaked on the web, because they re-used the same...

  • Reply To: Collecting Toxic Waste

    Continuing down the PII = Technical Debt side track, I'm thinking that in an ideal scenario, an OLTP databases, data warehouse, data lake, etc. should not contain PII - only...

  • Reply To: Collecting Toxic Waste

    Another form of technical debt is needless personal identifying information (PII) that accumulates in our databases and file systems. I've sometimes analogized it to toxic waste, because of the way...

  • Reply To: A Data Request Form

    California's CCPA laws are already in effect for "show me my data" and "delete my data" requests, but there are other US states planning to rollout in near future as...

  • Reply To: Extreme SQL

    What's essential is knowing what data access patterns are being used by each application and then partitioning, structuring, and indexing the data optimally. For ad-hoc aggregate reporting on millions or...

  • Reply To: Automatic Install of Azure Data Studio

    Having that ADS shortcut available on the Windows Start menu will certainly lead to an increase in adoption, so maybe that's the idea of bundling it with the SSMS install....

  • Reply To: Do What Hurts

    At least in the realm of IT, if you find a task hard or tedious to do, then there is probably a better way of doing it.

  • Reply To: The Pace of Data Platform Change

    The thing is, change doesn't happen equally or universally. For example, here in the US, a significant percentage of the population still use dial-up and DSL, not because they are...

  • Reply To: The Separation of Tools

    I can see why keeping SSMS and ADS separate, both in functionality and as an installation, would make sense at this point, because it's on-prem versus Azure.

    However, I have been...

  • Reply To: The Separation of Tools

    Jeff Moden wrote:

    Let's hope they keep them separate forever and realize that not everyone is ever even going to go near Azure and that SSMS needs to be maintained.

    I'm guess...

  • Reply To: SQL Server Phone Home

    There should be a way to block this traffic using a firewall rule. I doubt if SQL Server would stop working just because it can't post or ping Microsoft support...

Viewing 15 posts - 1 through 15 (of 5,717 total)