Forum Replies Created

Viewing 15 posts - 481 through 495 (of 6,022 total)

  • Reply To: Technology Flows Downstream

    I'm not sure if a current or near future SQL edition will do this, but in Cosmos DB, throughput is provisioned using request units per second (RU/s), so the number...

  • Reply To: Segments for Protection

    In most places where I've worked, to access some of the more important production database servers, even as a sysadmin, it is required to login to a MFA protected VPN...

  • Reply To: Segments for Protection

    If your organization uses Azure Active Directory, then maybe it's visible to you somewhere in the portal. For personal Microsoft Live accounts, there is a Recent Activity feature where you...

  • Reply To: SSMS or SSDT

    I use Visual Studio or SSDT for SSIS package development and schema / data comparison. However, I find the UI too cluttered and AppDev centric for it to replace SSMS...

  • Reply To: VMs are not VMs

    This is why so many folks are moving their databases to Azure. Instead of debating about VMs, Cores, and storage controllers, it's simply setting the right DTUs (database transfer units)...

  • Reply To: NOSQL and RDBMSs

    A better term for "NoSQL" databases would be "ACID-ish" databases.

  • Reply To: Upgrade from SQL Server 2008R2 to SQL Server 2016 sp 2 performance issues

    Here is one possibility. Back when we were upgrading servers from 2008 to 2014/2016, we encountered the issue described in the blog post below. Confirm that a SKU licensing misstep...

  • Reply To: Cloud Pace

    Today, the modern IT professional has to be more "cosmopolitan" in regards to knowledge and expertise. It's not like the old days where someone could spend a decade embedded in...

  • Reply To: The Worst Comments

    Another example of bad commenting in code are when the comments contain actual blocks of commented code with no explanation. Like, if someone tweaks a 100 line SELECT statement, there...

  • Reply To: Mastery – Repetition, Variations, and Depth

    But, thanks to advancements in automation and the expanding pace of the IT ecosystem, we're all basically becoming a Jack Of All Scripts and Master Of None.

  • Reply To: Long Live All Passwords

    While I don't see biometrics as a complete identification solution or a replacement for passwords in all situations, I still think it could be a component of a more complete...

  • Reply To: High Prices for High Security

    "..Is it a big deal? I don’t know. Windows Server 2019 lists  with Datacenter at $6155 and Standard at $972. That means it will cost me $5,183 for Always Encrypted on...

  • Reply To: Long Live All Passwords

    A biometric ID is basically a "secret" hash, just like a password. Hackers can leverage network sniffing, spoofed login page, or some other man in the middle exploit to collect...

  • Reply To: How to read each record and erase duplicates in a column

    I see you have posted the original resultset, however, so we know for sure what the goal is, please post a sample of what the resultset should look like after...

  • Reply To: What Keeps You Employed?

    My answer depends on the situation. If I'm at the bank applying for a car loan or enrolling my kids in school, and I'm asked about my occupation, then I'll...

Viewing 15 posts - 481 through 495 (of 6,022 total)