Navigation

    ML
    • Register
    • Login
    • Search
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. Tags
    3. sql server
    Log in to post

    • MS SQL Server 2016 on Windows Server 2019?
      IT Discussion • sql server windows server 2019 sql server 2016 • • scottalanmiller  

      15
      0
      Votes
      15
      Posts
      118
      Views

      @scottalanmiller said in MS SQL Server 2016 on Windows Server 2019?: Trust me, we tried to go Linux. But it just didn't work out.
    • MS SQL Express cannot create compressed backups
      IT Discussion • sql server • • JaredBusch  

      4
      2
      Votes
      4
      Posts
      73
      Views

      @JaredBusch said in MS SQL Express cannot create compressed backups: @scottalanmiller said in MS SQL Express cannot create compressed backups: Would not have expected that. It is not a game breaker. The DB is only 1.2GB, but out of habit, i always compress backups with the native tools. This time I have to compress it after the fact. not a huge deal. Just annoying. Yeah, it's Express. Just seems like an odd feature to remove there. Definitely not a big deal, you can compress manually later.
    • MS SQL on Linux rpm missing in repo
      IT Discussion • linux microsoft sql server yum microsoft sql • • JaredBusch  

      2
      0
      Votes
      2
      Posts
      189
      Views

      @JaredBusch said in MS SQL on Linux rpm missing in repo: Good work Microsoft...... msodbcsql17-17.4.1.1-1.x86_64. FAILED https://packages.microsoft.com/rhel/7/prod/msodbcsql17-17.4.1.1-1.x86_64.rpm: [Errno 14] HTTPS Error 404 - Not Found --:--:-- ETA Trying other mirror. To address this issue please refer to the below wiki article https://wiki.centos.org/yum-errors If above article doesn't help to resolve this issue please use https://bugs.centos.org/. mssql-tools-17.4.1.1-1.x86_64. FAILED https://packages.microsoft.com/rhel/7/prod/mssql-tools-17.4.1.1-1.x86_64.rpm: [Errno 14] HTTPS Error 404 - Not Found --:--:-- ETA Trying other mirror. Error downloading packages: mssql-tools-17.4.1.1-1.x86_64: [Errno 256] No more mirrors to try. msodbcsql17-17.4.1.1-1.x86_64: [Errno 256] No more mirrors to try. There is no 17.4 in the repo... https://packages.microsoft.com/rhel/7/prod/ Something they released and then pulled, maybe?
    • UNSOLVED Veeam Agent for Windows VSS Snapshot Error with SqlServerWriter
      IT Discussion • windows backup windows server veeam disaster recovery sql server windows server 2012 r2 vss shadow copy veeam agent for windows • • scottalanmiller  

      7
      0
      Votes
      7
      Posts
      5284
      Views

      Our go-to solution for VSS problems is to set up a dedicated snapshot volume. Otherwise we were getting timeouts and M$ does ugly things that don't make sense when VSS doesn't work properly.
    • Make MS SQL Server 2014 Log Every Query
      IT Discussion • sql server logging sql server 2014 • • scottalanmiller  

      10
      0
      Votes
      10
      Posts
      624
      Views

      @pete-s said in Make MS SQL Server 2014 Log Every Query: @romo said in Make MS SQL Server 2014 Log Every Query: @pete-s said in Make MS SQL Server 2014 Log Every Query: Extended Events @Pete-S happen to know where the default location of the event files are saved? I created a new session and I believe it is properly showing the queries ran, but if I try to change the place where the file is logged to is doesn't start, but if I leave the default set I can't find the file!! I'm not sure the default is actually a file at all, it may be memory buffers. However it sound like you have a user rights issue. Make sure SQL server is allowed to write to the file where you put it. Also remember The SQL instance is usually not running with a user context. Generally a system service.
    • RDS 2012 R2 SQL Server Windows NT
      IT Discussion • sql server windows server 2012 r2 rds • • scottalanmiller  

      13
      1
      Votes
      13
      Posts
      647
      Views

      @donahue that's more of what we would expect.
    • Need some help with SQL Server 2016 Standard licensing (price confusion)
      IT Discussion • microsoft licensing sql server microsoft licensing sql server 2016 • • dave247  

      35
      1
      Votes
      35
      Posts
      1153
      Views

      @scottalanmiller said in Need some help with SQL Server 2016 Standard licensing (price confusion): @jaredbusch said in Need some help with SQL Server 2016 Standard licensing (price confusion): @dave247 said in Need some help with SQL Server 2016 Standard licensing (price confusion): @jaredbusch said in Need some help with SQL Server 2016 Standard licensing (price confusion): @dave247 said in Need some help with SQL Server 2016 Standard licensing (price confusion): @jaredbusch said in Need some help with SQL Server 2016 Standard licensing (price confusion): @dave247 said in Need some help with SQL Server 2016 Standard licensing (price confusion): @phlipelder said in Need some help with SQL Server 2016 Standard licensing (price confusion): @dave247 said in Need some help with SQL Server 2016 Standard licensing (price confusion): Hi friends. I am working on building a new physical server to replace one which is running older versions of Windows and SQL server, plus it is almost out of storage space so this needs to be done sooner than later. This SQL server is running a 3rd party application and they currently only support up to SQL 2016, so that's what I have to install - not 2017. And it's going to be SQL 2016 Standard Edition running on Windows 2016 Server Standard with 16 cores. I spent a while researching SQL sever licensing to try and get an idea of how much it's going to cost. I haven't dealt with SQL server licensing yet. First, I assumed that I would still have to purchase SQL Server 2017 core licenses with downgrade rights. So looking on the SQL Sever Pricing page, it looks as though Standard - per core price is $3,717 (2 pack). So if my server has a total of 16 cores, this is going to cost about $29,736 to cover SQL licensing. Then I checked over on CDW just to get an idea of prices and things and I had the idea to search "SQL 2016" when I found this: SQL Server 2016 Standard - license - 16 cores - with Server 2016 Standard for like $1,900. Is this even applicable to what I'm doing or am I missing something? It does say in the technical details "BIOS locked (Lenovo)" but I have no idea what that refers to. But other than that, it looks like it's licensing SQL Server 2016 for 16 cores and bundled with Windows Server 2016. Surly this can't be correct... or is it? If it is actually what I would need to be covered, I would purchase it, of course. Otherwise, can someone help me get an idea of what I should be paying for SQL Server 2016 Standard Edition for 16 cores if not the cost I initially calculated ($29,736)? And I don't think we'd do the server + cal licensing as we have about 80 users and 100 or more systems which would connect to the SQL server. Simple rule of thumb to ask your Microsoft licensing rep for the following: First option is license + CALs that allows internal access only with unlimited instances on the server and unlimited cores: SQL Server Standard License SQL Server Standard User CALs (80 Users) Second option is per core with a minimum of 4 to purchase: SQL Server Standard Per Core 2-Pack (2x) In the Per Core scenario we can license for the number of physical cores to use and delimit that in SQL Studio Management. When it comes to audit, a snip of that setting that only allows the four threads should be just fine. So if you license + CAL, do you have to cover all users AND computers? If you license by user you cover users. If you license by device you cover devices. Well what constitutes as a device? I mean, users use a device to connect to the SQL server... so wouldn't I have to cover both? I don't get it. That is never how Microsoft CALs have worked. ok, I finally re-read the overview.. makes sense again. We have a pretty even user/device ratio with slight fluctuations in both over time. I suppose we'd just do user CALs.. There is almost no reason for anyone in the normal, day to day, business world to use device CALs. Agreed, this is super specific niche stuff normally reserved for manufacturing shift work. We have a few clients that run two or three shifts across one or more facilities. A shared device by two or three peeps per day is about the only time we've ever deployed Device CALs.
    • How to back up your SQL Server databases to Azure without a hassle
      Starwind • azure database sql server sql microsoft sql azure backup • • Oksana  

      1
      1
      Votes
      1
      Posts
      272
      Views

      No one has replied

    • Verifying MS SQL Server 2017 Licensing
      IT Discussion • microsoft licensing sql server microsoft licensing sql server 2017 • • scottalanmiller  

      37
      3
      Votes
      37
      Posts
      1589
      Views

      @dustinb3403 said in Verifying MS SQL Server 2017 Licensing: @jaredbusch said in Verifying MS SQL Server 2017 Licensing: @scottalanmiller said in Verifying MS SQL Server 2017 Licensing: @jaredbusch said in Verifying MS SQL Server 2017 Licensing: @scottalanmiller said in Verifying MS SQL Server 2017 Licensing: @jaredbusch one of the complications is that there IS no virtual core. vCPU is NOT core. a vCPU has vCores. Always. It might just be one. That is how it works. Not in any system I've seen. What people call vCores are actually vCPUs. The vCPU might tell the OS it has multiple cores, but the idea of a vCore has never existed, only vCPUs. Vmware, KVM, etc. all the same. Core means physical, it's like having a physical virtual, it cancels itself out. I am almost certain that VMWare lets you make a 1 CPU VM with 2 cores. Hyper-V just says virtual processors. KVM says CPUs. But I very clearly remember some hypervisor letting me specify a vCPU and vCores. XenServer and XCP-ng also allow this. 1cpu 2 core etc. Topology lets you state presented cores, not vCores. Totally different things.
    • N

      Reindex WSUS Database on Windows Server 2016
      IT Discussion • windows server 2016 sql server wsus • • Neil Klawitter  

      12
      1
      Votes
      12
      Posts
      5282
      Views

      N

      I finally got this to work if anyone is interested. The sql file is fine, but I had to change my batch file. The correct one looks like this: "C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\sqlcmd" -I -S \.\pipe\MICROSOFT##WID\tsql\query -i C:\Scripts\WSUSDBMaintenance.sql It must be run from an Administrator command prompt. This took me several days to figure out so I hope it can benefit someone else. Everything I found about reindexing the WSUS database was on Server 2008 or 2012. This works on Server 2016.
    • Microsoft SQL Server. AlwaysOn AGs. DR & BC
      Starwind • microsoft sql server failover cluster • • Oksana  

      1
      1
      Votes
      1
      Posts
      297
      Views

      No one has replied

    • Learn how to keep your sensitive data safe with SQL Server Always Encrypted
      Starwind • starwind powershell azure sql server sql server management studio sql server always on ssms • • Oksana  

      1
      3
      Votes
      1
      Posts
      303
      Views

      No one has replied

    • SQL Server Always On FCIs: whatever goes wrong, database and production survive
      News • high availability sql server failover cluster instances alwayson fci • • Oksana  

      1
      4
      Votes
      1
      Posts
      366
      Views

      No one has replied

    • Squeeze all the performance out of your Hyper-V with SMB Direct
      Starwind • hyper-v windows server sql server smb rdma smb 3.0 smb direct • • Oksana  

      1
      4
      Votes
      1
      Posts
      553
      Views

      No one has replied

    • System center configuration manager and SQL server
      IT Discussion • sql server design sccm system center configuration manager • • EddieJennings  

      2
      0
      Votes
      2
      Posts
      339
      Views

      @eddiejennings said in System center configuration manager and SQL server: For those who use SCCM, do you host the database on the same server as the SCCM application, or do you have SQL server as its own VM? I am replacing SCCM in our test environment, and will be doing the same eventually in our production environment. The current one has SQL server host locally. But since were looking to start over, I figured it would be worth weighing the pros and cons of keeping SQL Server local or having you be on the remote server. In my last job, we ran SCCM for a while and we had everything on one VM. (Small set up with ~200 PCs). It ran OK. I'd suggest keeping it to one host for your test environment, and separating them out for your production setup.
    • Machine software unabel to connect to new SQL server
      IT Discussion • encryption sql server connection string • • JaredBusch  

      9
      5
      Votes
      9
      Posts
      629
      Views

      Do you have .net4 installed on this xp client?
    • How to create developer and test environments in minutes with Azure DevTest Labs
      Starwind • microsoft azure sql server sql • • Oksana  

      1
      1
      Votes
      1
      Posts
      377
      Views

      No one has replied

    • Looking for version control for MS SQL Server
      IT Discussion • microsoft sql server version control • • JaredBusch  

      9
      1
      Votes
      9
      Posts
      650
      Views

      I've only ever used Redgate, but have heard good things about ApexSQL.
    • Sizing a Server and Disks - SQL VM
      IT Discussion • vmware sql server virtual machine esxi host • • hobbit666  

      112
      1
      Votes
      112
      Posts
      4101
      Views

      General Info ESXi1 – Dell R710 – VMWare ESXi5.0.0 2x Intel Xeon E5607 (4 core, no Hyperthreading) 64GB RAM 1TB Local ESXi2 – R610 - VMWare ESXi5.0.0 2x Intel Xeon E5645 (6 core, 24 Threads) 64GB RAM NO Local ESXi4 – R620 - VMWare ESXi5.0.0 2x Intel Xeon E5-2640 (6 core, 24 Threads) 64GB RAM NO Local
    • Scale HC3 Resources - MS SQL Server Backup Options
      Scale Legion • scale scale hc3 backup disaster recovery sql server recovery • • scale  

      1
      2
      Votes
      1
      Posts
      526
      Views

      No one has replied

    • Who needs an MSDN subscription?
      IT Discussion • windows server licensing sql server lab testing compliance • • EddieJennings  

      17
      1
      Votes
      17
      Posts
      1971
      Views

      @eddiejennings said in Who needs an MSDN subscription?: @bigbear said in Who needs an MSDN subscription?: @tim_g said in Who needs an MSDN subscription?: @eddiejennings said in Who needs an MSDN subscription?: This thread is inspired by the never-ending thread about licensing and replication in I Can't Even. I know that developers who use Visual Studio probably get their Visual Studio license through an MSDN subscription. One benefit of the subscription is that you're allowed to spin up Windows servers, SQL servers, etc., for development and testing. For organizations who have full-on lab environments or IT staff who need to spin up a VM Windows Server VM here and there to try something out, how do they stay in compliance? Do they also buy a MSDN subscription (perhaps MSDN platforms) for the IT staff member? Do they have their IT staff continually use Windows server 180-day evaluation licenses? Do they turn a blind eye as they give their IT staff activation keys from a dev's MSDN subscription and hope their organization is never audited? MSDN subscriptions are user-specific. To stay in compliance, every person who wants to take advantage of an MSDN benefit, will need to have their own MSDN subscription. They cannot be shared. Any VM spun up under the MSDN subscription cannot be used in any way by another person. Ah, didnt read the full OP post and assumed it was for him. However Bizspark MSDN does provide startup organizations with multiple user accounts all for internal use and testing. It is not for production or internal use. Yeah. It's not for me. I was just musing about the test VMs and such we need to spin up as IT, and I was curious how larger businesses or businesses with test labs license those test Windows VMs. I figured MSDN platforms wasn't used because of [see the above responses], but perhaps truth was going to be stranger than fiction. Larger is different. Once you are of any size you have enterprise agreements and your labs are just covered.
    • Appropriate Use of Hyper-V Checkpoints
      IT Discussion • virtualization sql server hyper-v 2016 iis redis checkpoint • • EddieJennings  

      5
      1
      Votes
      5
      Posts
      816
      Views

      @scottalanmiller said in Appropriate Use of Hyper-V Checkpoints: @eddiejennings said in Appropriate Use of Hyper-V Checkpoints: @jaredbusch said in Appropriate Use of Hyper-V Checkpoints: @eddiejennings said in Appropriate Use of Hyper-V Checkpoints: With this upcoming project of virtualizing our production stuff, I've been thinking through the appropriate use of checkpoints. I'm sure there are other articles on this, but this seemed to be a good read. My grand idea is that checkpoints would be used before installing Windows updates or some upgrade to an application. You take the checkpoint, apply the update, and if everything breaks, you apply the checkpoint. If nothing breaks, then you delete the checkpoint. I'm curious how this would be handled with a SQL Server VM or Redis VM. You'd update your VM, transactions start happening, then things break causing you to have to apply the checkpoint. Any transactions that were done would be lost, which upon further thinking probably doesn't matter, since you probably couldn't trust any data put into the database while the stuff was in the process of breaking. You have to make sure you don’t have transactions coming in. Simple as that. Anything is a headache waiting to happen. Makes sense. When I do maintenance on these normally, I stop IIS once downtime’s been announced, then do my work. So I’d just take the checkpoints at that point. I imagine once stuffs back up and I confirm things aren’t broken, Hyper-V just handles merging the avhdx file in such a way that SQL Server, etc is none the wiser. Or is there significant risk of stuff breaking if it’s running while that merge process takes place? No real risk. Just performance loss. And never enought to matter to any SMB workload I have ever had to deal with.
    • SQL Server Backup Design
      IT Discussion • virtualization sql server backup and disaster recovery veeam backup and replication • • EddieJennings  

      12
      1
      Votes
      12
      Posts
      1032
      Views

      @scottalanmiller said in SQL Server Backup Design: @jaredbusch said in SQL Server Backup Design: @tim_g said in SQL Server Backup Design: I'm with Jared on this one... Backing up through the application layer (SQL) as often as you can depending on change frequency. For example, every 15 minutes. Hourly and daily through the SQL backup tools. At least daily full VM backup at the hypervisor level. I prefer backups that use a standard file format, so you don't have to rely on Veeam for example to restore it. Veeam has screwed up too many times for me to want to rely on it like that. I have never had been fail Except for statements like this. For some reason Siri does not like Veeam yet. Even though correct it a lot
    • Choose wisely: SQL Server Failover Cluster Instances vs. Basic Availability Groups
      Starwind • starwind database disaster recovery high availability sql server ha sql server 2016 mission-critical database basic availability groups failover cluster instances dr bags fci • • Oksana  

      2
      3
      Votes
      2
      Posts
      1944
      Views

      @oksana Still backups are needed
    • Deploy SQL Server 2016 Basic Availability Groups without Active Directory
      Starwind • active directory database sql server starwind blog ad failover cluster sql server 2016 mirroring basic availability groups availability groups database mirroring ag wsfc bag • • Oksana  

      1
      1
      Votes
      1
      Posts
      911
      Views

      No one has replied

    • Comparing SQL Server AlwaysOn Availability Groups (AGs) and Basic Availability Groups (BAGs): Cost and Features
      Starwind • licensing sql server starwind blog failover sql server alwayson alwayson basic availability groups alwayson availability groups • • Oksana  

      1
      7
      Votes
      1
      Posts
      718
      Views

      No one has replied

    • SQL Server “Just Never Fails!” © with AlwaysOn Failover Cluster Instances (FCI)
      Starwind • disaster recovery high availability sql server starwind blog cluster failover cluster instances fci alwayson fci sql server alwayson zero downtime sql server alwayson failover cluster • • Oksana  

      1
      2
      Votes
      1
      Posts
      1797
      Views

      No one has replied

    • Using In-Memory Databases, Anyone?
      IT Discussion • database sql server sql performance databases apache geode in-memory databases • • NetworkNerd  

      18
      0
      Votes
      18
      Posts
      1641
      Views

      We have plans to add an in memory database to ML in the future when more performance is needed, as well.
    • SQL Log of a truncate action
      IT Discussion • sql server • • Grey  

      4
      1
      Votes
      4
      Posts
      827
      Views

      @grey This might help get you started. There are 2 types of change tracking for MS SQL. Pick the one most appropriate for your scenario. https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/track-data-changes-sql-server
    • Best Practices in Virtualizing SQL Server
      IT Discussion • virtualization best practices sql server sql best practices • • NetworkNerd  

      1
      3
      Votes
      1
      Posts
      529
      Views

      No one has replied